I have put the corrected formula in C1 and copied it down to the end, now
what? In the C1 column it now says duplicate in evry row, do I need to hit
the 'enter' key or do something else? This may be a problem, the sheet is in
a CSV format, will that effect it?

"Fred Smith" wrote:

Typo. Should be:
=IF(ISNA(MATCH(A1,B:B,0)),"","duplicate")

Regards,
Fred

"Pete_UK" wrote in message
...
Put this in C1:

=IF(ISNA(MATCH(A1:B:B,0)),"","duplicate")

and copy down to row 797. It will tell you which of the entries in
column A are duplicated in column B.

Hope this helps.

Pete

On Feb 5, 3:32 pm, George wrote:
I was given a formula that did not work before and need to try this again.
I have two lists which I have put in one worksheet, column A is 797 rows
long and column B is 319 rows long. I need to isolate the duplicates in
these
two columns so I can remove them and see what was not duplicated (all of
the
items in column B will be duplicated in column A)
The lists are labels which consist of letters and numbers some have spaces
and other have signs like - , ( , ).
The lists are of finished items and un-finished items, the finished items
will be duplicated, so by removing those lables I will be left with the
un-finished items.
Any help with be appreciated.