Dear All ,
I have million rows ,
I have columns A to N ...the N may vary and i wish macro to self find the range using the range function and columns.count x1left function ,
Second in each of the rows ,i want macro to check A,B,C,D,F .if they are same ,i want them to be deleted using the following logic
If there are 5 rows X1,X2,X3,X4,X5 with identical data in A,B,C,D,F i want E column to be checked for each of this 5 rows ...keep the one with the largest string length ,i want rest all to be deleted .....in case data in cell E is same and repeats in all 5 entries ,i want all except 1 to be retained ...
While rows get deleted ,i want them to be deleted in entirety and not in range of A:F or etc ,i wish order to be maintained while tis process is carried out and that is why i have kept the last column as row number ,
i would wish someone to use loop and solve it for million entries ......if anyone can capture in ceryain cell rows getting deleted and duplicate entries ,it will be highly appreciated
i Hope that i have been clear enough outlying my requirement ?
Thanks ,
Amlan Dutta
Bookmarks