Thread: How to delete all duplicate records - without keeping one of them
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Aviva B Aviva B is offline
external usenet poster
  
Posts: 1
Default How to delete all duplicate records - without keeping one of them
If I have a list of records, I know I can get rid of duplicate records using
an advanced filter - unique records only. But what if I want any record that
is duplicated to be deleted entirely from the list?
For example, if I have a list of:
1
2
2
3

How can I get only 1 and 3 to be left?

Thanks.
Reply With QuoteReply With Quote