Flashbond
09-23-2012, 01:58 PM
First of all hi to everyone! I am new member and this is my first post :hi:
I asked this question in another forum but didn't get a satisfaying answer yet: mrexcel.com /forum/excel-questions/660935-visual-basic-applications-sort-duplicates-top.html
I wanna sort A1:A5 values as if there are duplicates Left(Range("A1:A5").Value, 4), will be on top of the column A.
Briefly, if the first 4 letters of any value are the same in the given range, keep the other values and sort them to top.
Thanks a lot!
I asked this question in another forum but didn't get a satisfaying answer yet: mrexcel.com /forum/excel-questions/660935-visual-basic-applications-sort-duplicates-top.html
I wanna sort A1:A5 values as if there are duplicates Left(Range("A1:A5").Value, 4), will be on top of the column A.
Briefly, if the first 4 letters of any value are the same in the given range, keep the other values and sort them to top.
Thanks a lot!