See which names are duplicates

[Closed]
Report
-
Posts
16867
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
September 21, 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
16867
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
September 21, 2021
5
do you intend matching the first names as well? please provide more details.
Posts
16867
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
September 21, 2021
5
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.