Forum Discussion

Copper Contributor

Dec 04, 2020

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...

Example data.xlsx11 KB

excel

Excel on Mac

mathetes

Gold Contributor

Dec 04, 2020

there appears to be something wrong with your attached file. Could you try it again please

poholekc
Copper Contributor
Dec 04, 2020
mathetes I'm not sure what is wrong with the file? Opens fine for me. I attached it again and also as .xls file.
Example data.xlsx11 KB
Example data.xls31 KB
- mathetes
  Gold Contributor
  Dec 04, 2020
  poholekc
  
  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.
  - poholekc
    Copper Contributor
    Dec 04, 2020
    mathetes Trying again...
    Example data.xls31 KB
    Example data.xlsx11 KB