VBA- Filter not equal to with Special characters and phrases

[t7979rb]

I am trying to create a filter with NOT EQUAL TO on a large table. The filter column has phrases and phrases with "/" and "-" type special characters. A small example is attached. I want to filter on the column names Title. I need the result to be the last row "Technical Lead Engineer only. I need to use the "NOT EQUAL TO" since I have approx. 1000 rows and I want to see all except the 10 I select. Here is my code, For some reason the "SIR Engineer" row seems to filter out and not the other two. Any suggestions?

Sub Filt()
ActiveSheet.ListObjects("Table10").Range.AutoFilter Field:=2, _
Criteria1:=Array("<>Structure/Chassis/Body _ Engineer", "<>SIR", "<>SIR Engineer"), Operator:=xlAnd
End Sub

Dept	Title	Time
Safety	SIR	0.160097​
Durability	SIR Engineer	0.007352​
NVH	Structure/Chassis/Body _ Engineer	0.012752​
NVH	Technical Lead Engineer	0.004267​

 

[samitnair]

I dont think we have a straight forward approach to it like what you did. There are many workarounds though

 

[QuietRiot]

You have to either use advanced filter using a criteria range with 3 titles like the below OR create a helper column in code and use normal auto filtering from that instead

Title	Title	Title
<>*SIR*	<>*SIR Engineer*	<>*Structure/Chassis/Body_Engineer*

..

 

[t7979rb]

Thanks all. Question
If I don't use the <> function it works. Do you guys know if there is a way to reverse the filters.

 

[QuietRiot]

Thanks all. Question
If I don't use the <> function it works. Do you guys know if there is a way to reverse the filters.

The limitation is with not equal and also wildcards and you can only have 2. The equal to criteria you can have many in an array.

 

[t7979rb]

Thanks