See which names are duplicates [Closed]

Report
-
Posts
15104
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
April 12, 2021
-
Hi,

I have a massive list of about 12,000 names and then another list of about 1000 names, formatted in different columns such as
First Name | Last Name

I am trying to see how many of the 1,000 names are on the list of 12,000. Is there a way for Excel to quickly highlight duplicate names?

Thanks!

1 reply

Posts
15104
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
April 12, 2021
4
do you intend matching the first names as well? please provide more details.
Posts
15104
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
April 12, 2021
4
A possible solution is to make a collection of the 1000 names, and, hightlight each of the 10000 names if they are present in that collection.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!