Excel - AutoFilter on multiple criteria

[DAmoss]

Hi,

I want to AutoFilter cell values are between (<=-11 And >=11) And between (>=-24 And <=24), thats both at the same time. Unfortunately, I'm totally lost on how to create the above range checking, any help would be much appreciated.

Here's my current code below, I can filter one way, but not both together:

With Sheet1

.AutoFilterMode = False

.Range("TrafficRange").AutoFilter Field:=1, Criteria1:="<=-11", Operator:=xlAnd, Criteria2:=">=11

.Range("TrafficRange").AutoFilter Field:=1, Criteria1:=">=-24", Operator:=xlAnd, Criteria2:="<=24

End With

 

[PHV]

How a value may be <=-11 AND >=11 ?

Anyway, for complex filtering, have a look at AdvancedFilter.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[DAmoss]

Maybe I should have explained better, the filter should show a value:

between (-11 to -24) And between (11 to 24) only

 

[PHV]

If you don't want to follow the AdvancedFilter route you may consider applying an AutoFilter to a derived column containing the Abs value of your TrafficRange's first column.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886