Get rid of Duplicates

  • Thread starter Thread starter J.Robinson
  • Start date Start date
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
 
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

Delete duplicates 4
Access Auto Matching Duplicates? 0
Filtering Issue 1
Remove Rows That Are NOT Duplicates 4
Augmenting an integer in a column to reflect duplicates in another 23
How to delete all duplicate records - without keeping one of them 5
Excel Comparing two columns 1
How to remove duplicated data repeated in a column and keep just o 5

Back
Top