Forum Discussion
poholekc
Dec 04, 2020Copper Contributor
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...
mathetes
Dec 04, 2020Gold Contributor
there appears to be something wrong with your attached file. Could you try it again please
poholekc
Dec 04, 2020Copper Contributor
mathetes I'm not sure what is wrong with the file? Opens fine for me. I attached it again and also as .xls file.
- mathetesDec 04, 2020Gold Contributor
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.
- SergeiBaklanDec 04, 2020Diamond Contributor
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