Hey Folks,
I have a program that generates 10,000 rows of information.
After sorting them by a few columns, I end up with around 6,000 more rows
than I need since there are many near duplicates.
What I would like to be able to do is run a macro that essentially would
read something like this :
if A5 = A4 and B5 = B4 and C5 = C4 then delete row 5
Any help would be appreciated.
Each row has about 30 columns in it and no entire row ever matches any other
row, so just matching a few cells of the row above it is all I need to
determine if the next row needs to be deleted.
Thank you for any help.
Steve