Forum Discussion
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...
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.
I do the first option
