Forum Discussion
Not getting an option to sort largest to smallest, only A to Z
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.
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).
- I do the first option
"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
