EXCEL 2013 FILTER MULTIPLE NOT EQUAL TO CRITERIA
Posted on 2014-07-12
See the attached file.
I am trying to write a Macro to:
Filter to display rows where IF NOT EQUAL to the following in Column D: TKT, HTL, CAR, SFE
Other data in the D column may vary.
I wrote this but it didn't work!!!:
ActiveSheet.Range("$A$1:$Z$5000").AutoFilter Field:=4, Criteria1:= _
"<>TKT", Operator:=xlAnd, Criteria2:="<>HTL", Operator:=xlAnd, Criteria3:="<>CAR", Operator:=xlAnd, Criteria4:="<>SFE"
Gail (in Australia)