Forum Discussion
Solved
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.
RohitNaval Then I suspect that your "numbers" are in fact texts. What do you get when you enter =ISNUMBER(<cell reference>) where the cell reference is a cell where you have the number? FALSE? Then it's not a number. If not, perhaps you can upload an example of your schedule.
ISNUMBER returns TRUE for cells where I have a number and FALSE where the cells are empty.