Delete duplicate rows with same data in certain columns for million rows

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