Exclude Rows with certain data

   
Name  No Type
A 12 1* Manager Water
B 26 3* Engineer
C 48 5* Manager Pipeline
D 59 3* Sr. Engineer
E 66 1* Sr. Manager Tax
F 33 5* Assistant 
   

 

How can I exclude rows which has "Manager" in column "Type?

I tried the exprssion = [Type] Not in "*Manager*", but it is not working.

Can somebody please help me

(1) Answer

Login