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

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

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
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Vass" wrote in message
o.uk...

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

"Don Guillett" wrote in message
...
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
--
Don Guillett

cheers Don
--
V

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

.