Finding Duplicate Cell Entries
Hi,
You can do that with a formula. Put this in an empty column and drag down.
It will show TRUE if a title is duplicated. Alter the column C range to suit
=COUNTIF($C$1:$C$20,C1)1
Mike
"John" wrote:
Is there a simple macro/VBA for checking a specific column in which there are
random duplicate text entries? I do not want to delete, remove or move them.
For example my Column C contains about 2000 song title entries some of which
are duplicates and I need to identify and tag them. I only need to ID them
for now. The simpler the better.
Thanks
--
John
|