search criteria - auto filter

[PAG]

Hi,

Is there another VBA way I can use to show more than 2 values to search for
in a column. I would like to seacrh for 3 value in a column and show the
results in the entire row.

Selection.AutoFilter Field:=15, Criteria1:="=*fid*", Operator:=xlOr, _
Criteria2:="=*COLCHESTER*" I wanted to also search for a third
value of Criteria3:="=*TAX-EXEMPT*"

Hope that make sense.

Peter

 

[Dave Peterson]

You could learn about advanced filter (using a criteria range).

Or you could use a helper column that has a formula that does that for you.

=or(countif(o2,"*fid*")>0,countif(o2,"*colchester*")>0,countif(o2,"*xx*"))

This would return True or false. Then filter by this to show the True's.

 

[Dave Peterson]

ps.

Debra Dalgleish shares some notes about advanced filtering with a criteria
range:
http://contextures.com/xladvfilter02.html