Hello all,

I have some data that I would like to hide depending on two different drop down boxes, the twist (for me at least) is that I don't want the section of one to affect the other.

i.e.

If I were to select an option from the first drop down box that hid 30 cells, I want them to be excluded from the effects of the next drop down box and vice versa. Additionally I would like the option that when the entry "All" is selected all the rows are made visible except for those that would be hidden by the option set in the other drop down box. (i/e both would have to be set to all for all rows to be visible)

hope this makes sense?