Data Validation Filter

**benno87** · 08-30-2009, 07:27 PM

Hi,
I am using a number of lists that act as filters for a range of cells.
For the filters, I have a few selections for each and I also would like to have an all filter (no filter) but without the formula being too lengthy (or code). Is there an easy way to be able to not use a specific filter if a certain selection is made ("All" for example)?

Hope this makes sense, I appreciate any help!

Cheers

**shg** · 08-30-2009, 07:34 PM

For example, ...

**benno87** · 08-30-2009, 07:45 PM

Hi Shg,

Thanks for your help.

Attached is a sample of what I have. Unfortunately, I have had to take the other sheets out, due to their sensitive nature.

But basically what I am asking is if the Country or Group list is set to "All", is there a way to avoid using the filter - say in a sumifs. But if it is set to "CW" or "EW", the filter to be used in the formula/code? I'm leaning towards code being the only way to keep it as breif as possible.

I hope you can now understand my problem and assist in some way.

Cheers

**shg** · 08-30-2009, 07:52 PM

Neither of those cells has any dependents, so ...?

**benno87** · 08-30-2009, 07:53 PM

No need to worry. I just figured it out - if I create a selection in the list that is "*", it will search for anything. That's what I was after.

Thanks for your time anyway, cheers!