Filter critetria

[Genzz]

Hi All
I need to more than 2 criteria filters in one column, I using this code but doesn't work.

Sub filter2()
'
' filter2 Macro

    Selection.filter Field:=1, Criteria1:=">BV53", Operator:=xlOr, _
        Criteria2:="<BV190", Operator:=xlAnd, Criteria3:="<>*c*"
    Selection.AutoFilter Field:=2, Criteria1:="8.00%"
End Sub

Many Thanks
Genzz

 

[BrianB]

I am not an expert in this because I generally use pivot tables. However, using Data/Filter/Advance Filter it is theoretically possible to have as many criteria as you want.

It requires that a separate Criteria range is set up. The best method is to copy/paste the column headings, and then put criteria underneath. This range has to be on the same worksheet, so I find it best to put it *above* the main table otherwise these rows get hidden too.

There needs to be an empty row above the table. Do not include empty rows in the criteria range otherwise nothing happens. It is possible to put references to other cells in the criteria range. Excel makes a named range called "Criteria".

After filtering we get the menu option to "Show All".

It is possible to copy filtered data elsewhere *in the same worksheet*