delete row if duplicate

[Vass]

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

 

[Vass]

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....

 

[Don Guillett]

A macro that looks at col F and col H
sub deldups()
for i = cells(rows.count, "f").end(xlup).row to 1 step -1
if cells(i,"f")=cells(i,"h") then rows(i).delete
next i
end sub

 

[Vass]

A macro that looks at col F and col H
sub deldups()
for i = cells(rows.count, "f").end(xlup).row to 1 step -1
if cells(i,"f")=cells(i,"h") then rows(i).delete
next i
end sub

cheers Don

 

[Megan]

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.