Forum Discussion
Filter no choice between number and text
In a table when I put in a filter and I want a number filter EXCEL automatically puts in a text filter and I want a number filter. EXCEL Does not give me a choice. There are blank cells in the column...
because I am not only interested in the fact that a day is negative or positive , I need to know the size of the changes. It is only one factor out of hundreds that I look at.
Of course you're interested in size, i.e., magnitude of numbers, not just direction (positive or negative), and that's why what I wrote mentioned Excel will automatically highlight negative NUMBERS in red, positive in black.
I do the same. I also use FILTER and other functions to extract those with largest magnitude (positive or negative) or largest change.....
My main point was to say if you're trying to use the Filter menu tool and running into obstacles because of the numeric vs text matter that you posted about, there are other ways to accomplish your objective. Excel almost always offers users different routes from point A to point B...part of the fun of using it is to explore those alternative routes.