Taking out duplicates from a single sheet
 

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


--
PokerZan
------------------------------------------------------------------------
PokerZan's Profile: http://www.excelforum.com/member.php...o&userid=23480
View this thread: http://www.excelforum.com/showthread...hreadid=379682

Poker,

I think Chip Pearson has some stuff on handling duplicates.
www.cpearson.com.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"PokerZan" wrote in
message ...

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


--
PokerZan
------------------------------------------------------------------------
PokerZan's Profile:
http://www.excelforum.com/member.php...o&userid=23480
View this thread: http://www.excelforum.com/showthread...hreadid=379682