I have a excel data base that has data entered from various sources and therefore sometimes ends up with some duplicate entries.

Each row has a special ident number so the total row is not duplicated.. only the data after the ident number.

How can I test the total row to see if it is a duplicate(other than the ident) and delete other than the first appearance, and keep its ident number intact.

I tried the unique filter but that seems to apply to the entire row

Thank to all