Forum Discussion
Improper sorting of text using custom sort list
I have two columns; column A is formatted as text and consists of a word followed by a space, then numbers (1-3 digits), column B is numeric. I want to sort by column A using a custom list rather tha...
there appears to be something wrong with your attached file. Could you try it again please
mathetes I'm not sure what is wrong with the file? Opens fine for me. I attached it again and also as .xls file.
I'm not sure either. If you go back and look at the original, you'll see that its size is given as 1KB, a fraction of these most recent.
HOWEVER, even your most recent generate this error message when I try to download them.
Total length on the list as SUM(LEN(range)) is about 2000 characters, includes invisible characters between items. Last items in your range are not in the list, you may check in dialogue box. Thus they are sorted wrongly. The workaround is to create helper column to the right of your list like 1,2,3,4,... and sort on it.
All details are here Custom List Limits - Excel Tips - MrExcel Publishing
