View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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