Creating a macro to find duplicate names

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?

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","")

--
Jim
"Carter Devereaux" <[email protected]> wrote in
message news:[email protected]...
| 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?