Hi there, I'm new to filtering so I hope this can be done and that I can explain myself clearly!

I have a massive worksheet that I need users to be able to filter easily to simplify their tasks. The trouble is, different users need to filter based on different columns, and the current filtering options are a bit too complex.

Ideally, I'd like to enable filtering on about 3 of the columns (not all of them, as all those grey arrows will just confuse users). I'd also like the filter to behave like a drop-down, ie a nice simple option to select just one of the options in the list, and hide everything else.

Is this possible?

For example, our data-entry girl wants to show only the full list of products from a single supplier, in order to manually update that supplier's price list. Our product manager wants to see only those products in a single category, so that he can compare products and pricing from different suppliers. The whole sheet will contain all products from all suppliers.


Thanks in advance for any help!