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?

Post a sample of your worksheet so we can see what's going on. Show a before and after snippet.

Read this:

http://www.computing.net/howtos/sho...MIKE

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

Please read this http://www.computing.net/howtos/sho...

and repost your data.

I can't figure out what goes where.

MIKE

Ask Your Question

Weekly Poll