Advanced Filter on Excel using multiple AND / OR filters

Question

I am having trouble filtering my document using multiple "and, or" clauses on columns in excel.

My document has 27,000 rows and 37 columns. In the first initial rows I have my advance filter set in place I have attached a picture of how my advanced filter is set now. The resulting product of the filter I have set up is not what I intended. In human readable form I was trying to ask "What numbers in the 0-30 column rise above 2, and of those numbers that rise above 2 in the 0-30 column which fall back under .5 in one or more of the subsequent columns."

I appreciate anyone who takes the time to help me translate my human readable format into machine code, if you need further information please let me know.

Answer 1

You were almost there. You just need to continue the >=2 down column A while continuing to stagger the <=0.5 filters one column at a time.

        
                        ^{Setting up the criteria}

The theory behind this is that values across columns in a single row are treated as AND criteria while values in subsequent rows are treated like OR criteria. You want a combination of both.

^{WHERE (column A >= 2.0 AND column B <= 0.5)
        OR (column A >= 2.0 AND column C <= 0.5)
        OR (column A >= 2.0 AND column D <= 0.5)
        OR (column A >= 2.0 AND column E <= 0.5)
        (etc ...)}

        
                        ^{With Advanced Filter applied}