Toggle / Switch option under filtering
If we have large number of data in table and we want to see data belongs to few filters and then rest of the data. Say I have data for 100 cities and wanted to see data of 30 cities first and then rest of 70 cities. In first filter action I can select 30 cities and can look for its data and for rest I can just use toggle option to select rest 70 and unselect earlier selection of 30.
Exactly what I need - in my bad English I would have called the feature I need "to invert the filter"., but yes, I'm really missing this option.
If its easier for you programming guys "clear filter" or "unmark all filters" would help, too.
But not only for Excel for Mac, but also Windows verion please.