Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
search criteria - auto filter
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
search criteria - auto filter
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. PAG wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
search criteria - auto filter
ps.
Debra Dalgleish shares some notes about advanced filtering with a criteria range: http://contextures.com/xladvfilter02.html Dave Peterson wrote: 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. PAG wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Filter - capture criteria used | Excel Discussion (Misc queries) | |||
auto filter doesn't return cells containing the custom search wor. | Excel Worksheet Functions | |||
Auto Filter by Criteria | Excel Worksheet Functions | |||
Using advanced filter to search for criteria in a list | Excel Discussion (Misc queries) | |||
How do I show Auto-Filter "Search" Criteria on Sheet1? | Excel Programming |