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
|