PDA

View Full Version : Sort duplicates on top



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!

Flashbond
09-23-2012, 04:28 PM
Solved: ozgrid.com/ forum/showthread.php?t=170082