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
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