I have a requirement to hide NULL values from a filter without deleting .
how to achieve that?
We can achieve by using SET and excluding NULL.
But my requirement is not to exclude , rather it should be included and hidden.
Please attach some workbook with fake data.
How can we hide Null from Filter drop down but not from View?
Please Check the below attachment if it is correct or helpful for you.
Amar D. Savale
Retrieving data ...