Looks like you just need to find out duplicates in Col A. If that is the case
then enter this in C1
=COUNTIF($A$1:A1,A1)

It will give you 1 against the value when it occurs for the first time, 2
for the second time and so on... You can filter on 1 to delete duplicates.



"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.