Taking out duplicates from a single sheet

[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

 

[Earl Kiosterud]

Poker,

I think Chip Pearson has some stuff on handling duplicates.
www.cpearson.com.