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