Advanced filters with multiple criteria

Hello guys and gals Sorry in advance for the length of the post (and the bad spelling/grammar)

The thing is this: I want to apply 3 different filters to a matrix (the example sheet is pretty self-explanatory) I wanted to filter once, twice and one final time (and voilá) but.. I didn't work, apparentely, excel deletes the previous filter. So yes, I want to keep the previous filters and keep adding others to them.

By making the criteria range G2:I5 excel shows the results for (Blue and February and Monday) OR (Green AND Tuesday) OR (Red)

But what I WANT:

Results for (Blue OR Green OR Red) AND (February) AND (Monday OR Tuesday)

I made two tabs, one with the results, and the other one with my desired results.

I want it to program it with VBA of course I tried with dynamic named ranges, but it's not working for me, I also tried copying the filtered data from one filter (say, Blue OR Green OR Red) and apply the next and so on, but It doesn't really work either.

Is there a way? Should I give up?

Hi Alicita,

Don't give up. You simply don't have the statement of what you want agreeing with your Advanced Filter Criteria.

You just have to get your ANDs and ORs correct in your Criteria range.
see http://www.meadinkent.co.uk/xlfilter.htm

See sheet 1 where the correct criteria filters out your desired results.

This problem remindes me of Truth Tables back in Logic Class.
http://en.wikipedia.org/wiki/Truth_table

You have to create these in your Criteria Range to do the filters correctly.

Hey... Mechanical Engineers are SMART!!

The Criteria range simply has the ANDs on the same row and the ORs on different rows. When you get a combination of them you just need to build the table correctly.

To see how Advanced Filters work in VBA, simply turn on the Macro Recorder and do a simple one. Turn off the recorder and go look at what was recorded. It will be pretty clear.

I can't help much more without seeing the how the "user defined list box" interacts with the criteria range.

You can put a validation list in the criteria range and simply change what is filtered using a dropdown. Also you can put a command button on the worksheet that will trigger the code to re do the advanced filter.