Excel Sorting - Finding Duplicate Entries

  • Thread starter Thread starter Roxanne
  • Start date Start date
R

Roxanne

Hello,

I have two Excel Spreadsheet with client names. But I want to find the
duplicates and create one file.

Is this possible without having to go through all 900 names?

Thank you
Roxanne
 
Bring the two lists into one worksheet, copy list from one to the end of the
other. Then use Advanced filter, to copy the full list to another location
and turn on the 'unique records only' option

In xl2003 you will find advanced filter in the data menu, the list range is
ALL of your names list, leave criteria empty, click 'Copy to another
location' (has to be on same worksheet), choose a suitable (empty column),
click 'Unique records only' and press OK.

Note: this is case sensitive and of course spelling, and any spaces at even
ones you cannot see at the end of name will be treated uniquely.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Deleting Duplicate Data in Excel 1
get Data Validation to stop, list supplied, duplicate data entries 1
finding unique values and removing all duplicates 4
Excel - Identify and delete duplicate rows 2
Macro to hide rows? 1
Delete duplicates based on time 2
Access Auto Matching Duplicates? 0
Macro for finding duplicate names 6

Back
Top