Hi,

I have a spreadsheet that grows everyday. Basically, A report generate
a load of new rows everyday and appends to a file. I then open the fil
and need to remove all duplicates. This is because if it exists mor
than once, the policy has been actioned...

So what I need from you guys is a simple piece of code to tell me i
there is a way to find all duplicates in a spreadsheet and delete al
rows where there is duplicates.

I tried looping through the rows but it takes about 4 hours!

Is there a simple way to delete all rows where they are duplicates?
However, the duplicates will have to be on 4 columns, A, E,F and G.
match on only one of these columns is not a duplicate.

Does that make any sense?

And

--
Message posted from http://www.ExcelForum.com