See which names are duplicates [Closed]

Question

See which names are duplicates [Closed]

Report

sam123 - Jan 4, 2017 at 02:50 PM
yg_be

Posts: 13943
Registration date: Sunday June 8, 2008
Status: Contributor
Last seen: January 18, 2021

- 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!

How to match names in excel where spelling differ
Naming hdmi inputs on lg tv ✓ - Forum - Smart TV
How to duplicate a page in google docs - How-To - Google
How do i count a list of names in excel? - How-To - Excel
Excel duplicate row multiple times ✓ - Forum - Office Software
Copy and insert rows and number of times ✓ - Forum - Excel

1 reply

Ask a question

yg_be · Answer 1 · 2017-01-04T15:21:00-0500

Answer 1 / 1

yg_be

Posts: 13943
Registration date: Sunday June 8, 2008
Status: Contributor
Last seen: January 18, 2021

4
Jan 4, 2017 at 03:21 PM

do you intend matching the first names as well? please provide more details.

Report

yg_be

Posts: 13943
Registration date: Sunday June 8, 2008
Status: Contributor
Last seen: January 18, 2021

4
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.

See which names are duplicates [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!