Get rid of duplicates

mklenehan

New Member
Joined
Aug 25, 2002
Messages
2
Hello.

I'm sure the answer I need is here somewhere, but I can't find it...

I need to compare 2 spreadsheets of data and get rid of the duplicate entries. The spreadsheets contain personal data of clients: address, phone#, SSN, etc...

How can I compare SSNs between the two sheets and weed out the duplicates?

Many thanks in advance.

meghan
 

Some videos you may like

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Ricky Morris

Active Member
Joined
Mar 31, 2002
Messages
363
In the first file use the match function to locate like SSN in the second file. Match will return a number if the SSN exist and NA# if it doesn't. You can then use filters to display the numbers (does not equal NA#) then delete these rows.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,908
Messages
5,574,969
Members
412,630
Latest member
Eireangel
Top