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*")
trying to do below code but not getting required results
Activesheet.Range("$A$1:$CT & lastRow").AutoFilter Field:=13, Criteria1:=Array("<>Bank*", "<>HDFC*","<>SBI*")