How to delete duplicates?

[Mitch Page]

Hello and Merry Christmas still ;-)

Now in the column to the right of OldSuspects you add a forumula and fill
down: =IF(ISNA(MATCH(A1,UsualSuspects,0))," ","DUP")

And in column to the right of UsualSuspects you add a formula and fill
down: =IF(ISNA(MATCH(C3,OldSuspects,0))," ","DUP")

========

Any idea how this works on a Mac using "numbers"? I tried the following but it didn't work ( didn't name the columns but used the column letters "A" and "C" respectively and I placed the formulas in the fields "B1" and "D1" respectively )

Now in the column to the right of OldSuspects you add a forumula and fill
down: =IF(ISNA(MATCH(A1,C,0))," ","DUPL")

And in column to the right of UsualSuspects you add a formula and fill
down: =IF(ISNA(MATCH(C3,A,0))," ","DUPL")

Thanks a lot

 

[Z. Watson]

Thanks Phil - great info, very helpful!