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.
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.
SergeiBaklan That is exactly what's happening. Most of the cells are empty and Excel is defaulting to sort alphabetically. Any way to change that sort option to numeric?
I did change the IFERROR formula from "" to 0 and now the sort works numerically. However I have so many zeros showing now.
You may hide zeroes through settings or by custom number format, here is how https://www.techrepublic.com/blog/windows-and-office/pro-tip-three-ways-to-hide-zero-values-in-an-excel-sheet/
While I have you, when a cell shows a green flag in the upper left corner, what does that indicate and how do I get rid of it? I have to manually get rid of it by selecting 'ignore error'.
