Hi
I have a spreadsheet that is filled with number arrays sepperated by a blank line
they are quite huge and i would need a vba to search through them and remove
the identical ones as fast as possible.
I have attached and example file.(book2.xls)
sheet1 is what i have but it runs into 1000's of cells(i have highlighted the identical arrays)
sheet 2 is basically what the answer should look like after the cleanup
Anybody able to assist
Regards
Jaco
Bookmarks