Creating a macro to find duplicate names

  • Thread starter Carter Devereaux
  • Start date
C

Carter Devereaux

I'm trying to locate all the duplicate names in a long list that I have. Is
there a macro or something that I could use to tell Excel to do that?
 
J

Jim Rech

What I usually do is sort by name and then insert a temporary column and run
a formula like this down it to mark the dups:

=IF(B1=B2,"X","")
 
Top