Removing BOTH duplicate entries

Hi,

I'm have a column list of a lot of values, and I am looking to keep only the unique ones. That means if I find duplicates, I want to remove BOTH of the values that make up the duplicate.

For example,

1 2 3 4 4 5 5

would become

1 2 3


If there is a formula involved, if you could please explain the formula that would be great. (I'm trying to learn as I go)

Thanks in advance,
Hfswjyr

Go to Advanced Filter..and check mark on "copy records to another location" and "unique records"...Now it will will give you 1 2 3 4 5..take the count of these (using Count IF) to your original table and filter the ones which have only count 1

Sorry, could you please explain the countif part?

What should be my condition on countif?

Thanks.

if the numbers are in column A, put in b1, countif(A:A,a1) will count how many times the value in a1 appears in the column. if this formual is copied down it will count the occurances for each line. It can then be flitered as already suggested to select when these values are 1

Regards

Dav

Aha! It's so easy in hindsight!

Perfect Dav, thanks a lot.

Here is a formula. See attached file.