Filter on likewise string in column (1 Viewer)

[suryu]

I Want to filter column A with name like "ESAF", "E S A F" OR any name like "FBI *"

column contain "ESAF", "E S A F" or ("FBI Bank", "FBI Bank ltd", "FBI Finance ltd" can be more with FBI*)

 

[CJ_London]

presume you mean using excel functionality, not vba. Use the custom filter option

Text Filters>Custom Filter

 

[suryu]

presume you mean using excel functionality, not vba. Use the custom filter option

Text Filters>Custom Filter

using VBA only

 

[suryu]

can anybody help me on this :

I Want to filter column A with name like , "ESAF", "E S A F" OR any name like "FBI *"

i am trying to do below code:

strName="FBI"

Activesheet.Range("$A$1:$CT" & lastRow).Autofilter Field:=1, Criteria1:="=*" & strName & "*", Operator:=xlOr,
Criteria2:="ESAF"

i want to add one more criteria for " E S A F". How to add? anybody suggest me

 

[suryu]

@arnelgp, please help me on this.

Thank you

 

[Isaac]

Is this really any different than your last post about this?

filter the value which should not start with string

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*")

www.access-programmers.co.uk

You're limited in the # of custom filters that can be added, using VBA or not.

You might need to write some custom code to loop through rows and hide them conditionally.

 

[suryu]

Is this really any different than your last post about this?

filter the value which should not start with string

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*")

www.access-programmers.co.uk

You're limited in the # of custom filters that can be added, using VBA or not.

You might need to write some custom code to loop through rows and hide them conditionally.

yes its different, i dont want to hide i just want to filter with given conditions

 

[Isaac]

yes its different, i dont want to hide i just want to filter with given conditions

Hmm. Functionally speaking, that's the same. "Filter" means that the rows that don't meet the given conditions will be hidden.
Therefore, if you want to use more filters than are available (2), you'll need to write custom code that hides rows which don't meet the conditions.

 

[suryu]

Hmm. Functionally speaking, that's the same. "Filter" means that the rows that don't meet the given conditions will be hidden.
Therefore, if you want to use more filters than are available (2), you'll need to write custom code that hides rows which don't meet the conditions.

okay fine is there any possibility to add one more criteria in my given code

 

[Isaac]

Filters are limited to 2, you will need to write custom code to hide rows that don't match the given criteria.

 

[suryu]

Filters are limited to 2, you will need to write custom code to hide rows that don't match the given criteria.

ok thanks