Hi,

Note this will delete BOTH duplicates.
In a helper column enter this formula and drag down to the length of your
data column

=COUNTIF($A$1:$A$12,A1)

Select both columns and sort on the helper column. Select all rows greater
than 1 and delete

Mike

"Aviva B" wrote:

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.