Try doing an advanced data then checking the box "unique records only". You
can then select copy this to another sheet. This will get rid of dups.
--
If this has helped you, please click Yes

Thanks,
Megan


"Vass" wrote:


"Vass" wrote in message
o.uk...
Hi Folks
I have 8000 lines to sort though, I need to get rid of duplicates
Can someone tell me how to remove a complete row if the one above has two
cells that are identical?
thanks in advance


ah ha, almost there
=IF(ISNUMBER(MATCH(F231,F230,0),+IF(ISNUMBER(MATCH (H231,H230,0))),"Dup","
"))

but commas or brackets are wrong....

.