Tushar Patel Posted September 4, 2019 Share Posted September 4, 2019 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 Link to comment Share on other sites More sharing options...
Kirsten Smith (she/her) Posted September 5, 2019 Share Posted September 5, 2019 Try something like: Find("Manager", [Type]) 0 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now