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

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

Top