Removing Duplicates and Associated Unique Value

I'd like to be able to identify truly unique records in a large database; NOT the unique records associated with groups of records.

For example:

1 1 1 1
1 1 1 1
1 1 1 1
2 2 2 2
2 2 2 2
1 1 2 2

I'd like the output:

1 1 2 2

NOT:

1 1 1 1
2 2 2 2
1 1 2 2

Any simple way of doing this?

Hi MarvinP,

I appreciate your suggestion; however, creating a helper column for 5000 records with so many columns for each would take too much time and too much room for error.

This is frustrating, because using the advanced filter (unique values) and deleting, I can get the output:

1 1 1 1
2 2 2 2

(i.e. one unique of each duplicate record)

And with the delete duplicates tool, I can get:

1 1 1 1
2 2 2 2
1 1 2 2

(i.e. one unique of each)

Argh!!

Thanks again nonetheless :D

I don't know about auto fill! lol

Any hints before I delve in??

Thanks again,

Andrew

Hi Marvin,

I noticed you use the COUNTIF function to compare the value with the rest in the column.

Can you use a similar method to compare a record (e.g. unique row of values) to all other records?

Thanks,

Andrew