Compare two columns (different length) and pt duplicates in new column

**dzap79** · 04-13-2009, 01:15 PM

I have two columns of data that are different lengths. I want to take the data in column A and find duplicates in Column B and then have whatever is not a duplicate in Column B show up as a list in Column C.

I have copied the two columns of data into one sheet. Would there also be a way to do this across two sheets?

Thanks for the help.

**Special-K** · 04-13-2009, 01:34 PM

Duplicates or those values in column B can be found by entering this formula

=IF(COUNTIF(B$1:B$564,$A1),VLOOKUP($A1,B$1:B$564,1,FALSE),"")

**dzap79** · 04-13-2009, 11:21 PM

Can you explain how or where I enter this information? I tried entering it in column C but it does not work. Please help. Thanks

**Special-K** · 04-14-2009, 09:03 AM

Enter it in C1 then copy/paste it down column C
Works fine in Excel 2007

Any values in column A also in column B get copied to column C, if not a blank appears in column C.

Once that's worked enter

=(IF(A1=C1,"",B1))

in D1 and copy/paste down column D. This will list the values not in column B