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...
You could change your formula to return a "0", and then us an averageIF formula that ignore's zeros.
Not sure if there are other zero's in your data though.
Not sure if there are other zero's in your data though.
It should not be so difficult it should be my choice. And adding a 0 also means I will have to add more steps in other places. There are also other advantages to seeing empty cells.
- You could add conditional formatting to the column to highlight blank cells, then filter by color; or create a second column next to the column where you want to continue to see empty cells that adds a 0 so you can use the secondary column to use a number filter. Otherwise, you'll have to live by Excel's limitations.
xsmplfy Thank you for the reply. Good options, I just want it to be an easy choice. I do quantitative
analysis on the markets. I look at hundreds of variables in every decision model, so doing it a few times would be alright but some of my data models have a thousand columns of data before I even start any analysis. So now for the most part I tabulate data, move it and do analysis in other tables.
