Hi.

My worksheet has many records duplicated and I'd like to find a way of removing all duplicates. I've tried to use the Avanced data filter, but am not getting anywhere by the using its Unique records function.

What I have is this, for example:

10000002 18/04/2001 1 0 0 0 0 0
10000002 18/04/2001 1 0 0 0 0 0
10000002 18/04/2001 1 0 0 0 0 0
10000002 11/02/2003 2 0 0 0 0 0
10000002 11/02/2003 2 0 0 0 0 0
10000002 11/02/2003 2 0 0 0 0 0

As you can see, the first record is duplicated, so shows 3 times, and the second record is similarly duplicated.

What I want is just the distinct or unique records, so I should end up with this:

10000002 18/04/2001 1 0 0 0 0 0
10000002 11/02/2003 2 0 0 0 0 0

It feels like this should be very simple but I'm not getting anywhere. The Advanced filter/unique records simply copies the whole lot to the new location.

I have about 50,000 records/rows, including duplicates.

Please help, it's getting urgent and I'm feeling stupid..!

Thanks.