Filtering - user select single option from drop-down list?

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!

You don't have to have those "grey arrows" on all columns. You can select just a few, but they have to be contiguous. (ie next to each other).

Once you have done that, the options available for selection change according to what filters have already been set.

Please remember, your request is clearer if you attach a sample workbook.
- Click on Go Advanced and click on the Paper Clip.
When you reply please make it clear WHO you are responding to by mentioning their name.
If we have been of assistance, please let us know. A little thanks goes a long way.
- Please click on the *Add Reputation button at the bottom of helpful responses.
Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

Sorry for the belated response, but thanks for the replies. Contiguousity(!) saved the day...

You're welcome, and thanks for the Reputation point.

Did you remember to mark the thread as SOLVED?

Regards,

David