Forum Discussion
Solved
Excel Customized Sort List
I have created a custom sort list in Office 365 in Excel and I'm trying to sort in the sequence of the list but it's not working. Does anyone have any suggestions on why it's not working?
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 "
Thank you for responding, I am trying to have the column sort the numbers in the order provided in the custom sort; should that work or am I doing something wrong? I did try what you provided but that didn't work. I sent the file in my first message.
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 "
Okay, having it cleaned up, will try again. Thank you so much. I will let you know the outcome.
Sincerely,
Sherry