delete row if duplicate
 

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

delete row if duplicate
 

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

delete row if duplicate
 

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

delete row if duplicate
 

"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

delete row if duplicate
 

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

.