View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Herb Martin Herb Martin is offline
external usenet poster
 
Posts: 6
Default Checking for duplicates?

There are probably a million "better" ways but the following
worked for me recently:

Add a sequence column and extend it from 1-# of items
so you can later restore the data to the current order if you
need to do so.

Sort on the desired column(s) for comparison.

Write a conditional formatting rule to show the line in red IF
the value in this field matches the next line -- apply and all your
dups are easy to spot.

Resort is desired; remove the sequence or renumber as desired.

It's stupid but it's quick.

--
Herb Martin
"Eric G" wrote in message
...
Can someone please tell me any easy formula/macro to use to check for
duplicates (text) in a column of text data?

Thanks! Eric