Get rid of Duplicates


J

J.Robinson

Hi

Could anyone tell me a simple way for getting rid of
duplicate customers in a database. I thought it may be
possible too sort them by phone numbers?

thanks
 
Ad

Advertisements

G

Guest

If you data starts in A1, put this in B1 and copy down, Then sort the data, copy and paste special - values and you have all unique entrie

=IF(COUNTIF($A$1:A1,A1)=1,A1,""

Alex
 

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


Top