Forum Discussion
RohitNaval
May 03, 2020Copper Contributor
Not getting an option to sort largest to smallest, only A to Z
I have a problem with my Excel spreadsheet where I do not get an option to sort numerically in descending order - largest to smallest. I only get an option to sort alphabetically. The cell values are...
- May 03, 2020
In addition, you don't have blank cells, you have cells with empty texts returned by =IFERROR(...,""). As soon as we have texts within the range, even empty, Excel suggests to sort alphabetically. With =IFERROR(...,0) most probably that will be numeric sorting.
annabellas
Mar 21, 2022Copper Contributor
RohitNaval I tried filtering my numbers but it just went 1, 220, 34, 460 etc instead of smallest to largest. I fixed it by converting the column I was trying to filter into NUMBER and then doing text to column. For some reason it wasn't converting to numbers until I did text to column. After that it allowed me to filter smallest to largest (1, 34, 220, 460 etc).
functionjustin
Dec 08, 2022Copper Contributor
"For some reason it wasn't converting to numbers until I did text to column." YES this finally works now. I was getting so frustrated. annabellas