A
andycharger
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
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