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...
This is what I am talking about. Sometimes I want a number filter and I do not get a choice. thank you for your response.
That's a very different Filter dialog box than the one I see. What version of Excel are you using? Mine is the most current version.
Do you have access to the FILTER function? A new "Dynamic Array" function...it also requires the most current version of Excel....given the kind of thing you're doing, I think you'd find it worth your while to have it.
https://www.youtube.com/watch?v=9I9DtFOVPIg