Compare two columns!!

June 9, 2011 at 05:46:12
Specs: Windows XP, 1.99 GB

I'm trying to compare two columns and pick out the identical ones However this is how I need the comparison to be done :
a c
b d
c a
d b

The first row of the first column should be compared with each row of the second column until the match is found. Then I need to copy the identicals into 2 other columns. Need some eyes on this...

See More: Compare two columns!!

Report •

June 9, 2011 at 10:34:39
re: "I need to copy the identicals "

In your example, all the values in the first column exist in the second column.

Just copy the first column and then duplicate it.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question