Previous Topic Next Topic

See which names are duplicates

Closed
sam123 - Jan 4, 2017 at 02:50 PM
yg_be Posts 23541 Registration date Sunday June 8, 2008 Status Contributor Last seen June 6, 2025 - 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!
Related:

1 response

Answer 1 / 1
yg_be Posts 23541 Registration date Sunday June 8, 2008 Status Contributor Last seen June 6, 2025 5
Jan 4, 2017 at 03:21 PM
do you intend matching the first names as well? please provide more details.
yg_be Posts 23541 Registration date Sunday June 8, 2008 Status Contributor Last seen June 6, 2025 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.