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
 
A

Alex

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
 
Top