Taking out duplicates from a single sheet

P

PokerZan

I have a sheet with 12k rows with multiple duplicate records. Is there
a formula driven way to delete the duplicate records?

This is a list of companies with multiple contacts, so I am looking for
a way for example to take the 6 or 7 identical records of John Smith and
leave the other 5 or 6 contacts for the same company. Now that I'm
typing this I'm realizing that in a list this big the likely hood that
we have the same first and last name is pretty high.

I'm sure I need to provide more detail but I don't know exactly what I
would need to provide.

Thanks,

PZan
 

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

Find duplicates in address register 2
Duplicates 2
Access Auto Matching Duplicates? 0
Removing Duplicates to another sheet 1
Find duplicates in Excel 2000 4
"Remove Duplicates" 3
list duplicates 2
locating duplicates 4

Top