Autofilter function Not Equal To with more than 2 criteria

[tarekgemayel]

Hello,

I have a huge list with 2000+ entries that i need to filter.
I know that if i have 2 criteria i can use

With rng
   .AutoFilter Field:=2, Criteria1:="<>4", Operator:=xlAnd, Criteria2:="<>10"
   .Offset(1).Resize(rng.Rows.Count - 1).SpecialCells(xlCellTypeVisible).EntireRow.Delete
   .AutoFilter
End With

However if i have more than 2 criteria, the method described above no longer works.

All the help is appreciated
Thanks
T.

 

[Peter_SSs]

Welcome to the MrExcel board!

Have a look at Advanced Filter rather than AutoFilter.

If you need more help, give us more details about what you have on your sheet and where it is as well as exactly what you are trying to achieve.

 

[tarekgemayel]

Thanks Peter.
Ill try that later, however for the time being i was able to solve my problem with a Helper Column displaying "TRUE" and "FALSE" value and then filtering accordingly.

 

[Peter_SSs]

OK. Thanks for letting us know that you are "resolved" for the time being at least.