filter the value which should not start with string (1 Viewer)

suryu

Member
Local time
Today, 05:07
Joined
Apr 3, 2020
Messages
84
I want to filter the column value which should not contain string starting with "Bank", "HDFC", "SBI"

trying to do below code but not getting required results

Activesheet.Range("$A$1:$CT & lastRow").AutoFilter Field:=13, Criteria1:=Array("<>Bank*", "<>HDFC*","<>SBI*")
 

Isaac

Lifelong Learner
Local time
Yesterday, 16:37
Joined
Mar 14, 2017
Messages
1,972
I think you might be limited to two criteria using that technique.
I was reading this:
includes some possible workarounds.
 

suryu

Member
Local time
Today, 05:07
Joined
Apr 3, 2020
Messages
84
yes that is the issue for two criteria it is working fine
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom