Add option to filter drop down list
i wants to add an option to filter drop down list which gives output as in inverse select in filter
example: in a column i have values as 1,2,3 & 4. In a filter firstly i selected with 1 & 3 then with the help of above idea which output is select 2 & 4 in filter.
I wish this feature existed - so many times I have scrolled through data, found the data/label you require - only to realise that you have not un-selected all. An inverse filter would allow you to unselect the data and then inverse - would be much quicker than scrolling all the way back up unselecting all data and scrolling all the way back down again.
It would also be useful to find data that errors #REF #N/A and inverse to see all correct data.
Saskia Jacobsen commented
I am sorry that I hadn't seen this. Today I added en new idea, called Reverse selection.
It is the same as this one.
Kenneth Barber commented
Yes this would be useful!