Comparing 2 columns Vs another two in excell

November 10, 2010 at 16:04:00
Specs: Windows XP
I have two compare two columns in excell say column A and B with two other columns Like C and D to find the rows where the numbers appearing in A and B also happen in C and D at the same time. then I have to filter twos columns that turn out to be the same and make them into a new documnet. Can someone tell me how to do the comparison and the filtering please?

See More: Comparing 2 columns Vs another two in excell

November 11, 2010 at 06:56:05
Post a sample of your worksheet so we can see what's going on.

Show a before and after snippet.

Read this:


Report •

November 19, 2010 at 13:22:23
I have one similar to that. My info comes from two dif systems, the left one lists them out with multiple records and repeats the number for each "find number". the second report on the right lists just 1 number with multiple references. I need to be able to compare these to see if there are any mismatches.

Any help would be appreciated

Number Find Number Number 2 Refrence
1CAP000337 C18 BBV16173 PCB
1CAP004768 C22 1CAP000337 C18
1CAP006069 C24 1CAP004768 C22
1CAP006069 C25 1CAP006069 C24, C25, C26
1CAP006069 C26 1CAP012005 C2, C5, C13, C23, C40, C41, C42, C43, C45
1CAP012005 C13 1CAP012512 C9
1CAP012005 C2 1DDE000032 D1
1CAP012005 C23 1NTC006100 U7
1CAP012005 C40 1RES000292 R29

Report •

November 19, 2010 at 13:33:22
Please read this

and repost your data.

I can't figure out what goes where.


Report •
Related Solutions

Ask Question