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

suryu

Member
Local time
Today, 11:17
Joined
Apr 3, 2020
Messages
86
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, 22:47
Joined
Mar 14, 2017
Messages
8,738
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, 11:17
Joined
Apr 3, 2020
Messages
86
yes that is the issue for two criteria it is working fine
 

Users who are viewing this thread

Top Bottom