Compare Two Coulmns & Find Duplicates.

[Little Master]

Hello guys, i have a sheet which contains more than 8000 names (in 1 column), & another sheet which contains around 600 names (in 1 column), is there any way wherein i can compare both the columns & find out duplicates if any ???

Sheet which contains 8000 names contains duplicate cells as well, but dat doesn't matter, i jst need to compare & confirm the sheet which has 600 names should be unique (Not included in 8000 data)

Thnx in advance....

[zbor]

You can do it with VLOOKUP function, just put FALSE at the end (wich look for exact match).
In that case you'll get something in result if there is any duplicated, and #N/A if there isn't.

[DonkeyOte]

It's not clear to me which sheet is being compared to which...

Assuming you're comparing the 600 names to the 8000 names and assume the 600 names appear in Column A on Sheet 2 and the 8000 names in Column A on sheet 1 then

Sheet2!B1: =ISNA(MATCH(A1,Sheet1!A:A,0))
copy down

Those returning TRUE in Column B are Unique.

[Little Master]

Thanks DonkeyOte formula worked gr8 for me.... ty alot...

& I really like the links in ur signature.... they are useful.....

[Little Master]

I copy pasted both the columns in one sheet & used formula given by u as :
=ISNA(MATCH(A:A,B1,0))
8000 names in column A & 600 names in column B, i m just curious to know is there any difference between =ISNA(MATCH(A:A,B1,0)) & =ISNA(MATCH(A:A,B:B,0)) bcoz both throws same results.....

[zbor]

Only in range. B:B would look whole B column and B1:B1000 will be limited. But if you extend to all range it's the same.