Forum Discussion
Excel Customized Sort List
SherryHoward You need to clean-up your data in column A, then it will work.I'm certain. Sorting "2P13H01" is not the same as "2P13H01 "
You need a helper column to SORT in the order you are looking for. Check the attached WB & read the instructions.
I'm sure this help U,,, confirm through reply,,, and if it works,, then please accept it as answer as well like.
Rajesh_Sinha I tried it but it didn't work. Maybe I'm not doing something right. But I followed your instructions.
It's very unfortunate that you are unable to handle your data, and the method I've shown,,, what else any one can do,,,, especially when I've used your WB and attached with my post as a solution!!!
Let me remind that NO NEED to clean the data in Column A,,, since don't have any WHITE SPACE !!
