Duplicate removal

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.

Originally Posted by royUK

Are these in one column?

No, they're each in a separate column, 8 columns in total.

select all the sheet
then go to data and remove duplicate
by this way, it will remove only rows which
are identical
try it now, it will work
thanks

Does Excel 2003 have a duplicate removal fuction? I know that 2007 has it in the ribbon however,I don't know if 2003 has the same function.

try this ...I'm sure if one of the Gurus would take a look at it they could write a simple macro for you but I did a work around and took the slow boat to China...lol

Try adding a concatenated column and then applying Advanced Filter. Worked for me with the example you gave.