See which names are duplicates

Closed
sam123 - Jan 4, 2017 at 02:50 PM
yg_be Posts 21099 Registration date Sunday June 8, 2008 Status Contributor Last seen February 2, 2023 - Jan 4, 2017 at 03:23 PM
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

yg_be Posts 21099 Registration date Sunday June 8, 2008 Status Contributor Last seen February 2, 2023 5
Jan 4, 2017 at 03:21 PM
do you intend matching the first names as well? please provide more details.
0
yg_be Posts 21099 Registration date Sunday June 8, 2008 Status Contributor Last seen February 2, 2023 5
Jan 4, 2017 at 03:23 PM
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.
0