Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I specify more than 2 criteria in AutoFilter
Seems the AutoFilter can have at most 2 criteria. I do have a need to have 3
or more criteria to filter out a column of strings. How can I accomplish this? Thanks! Felix |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I specify more than 2 criteria in AutoFilter
One method is to use an auxillary column for your filtering. You can put a formula into a new colun the would produce either a True or False and then you can autofilter on the true or false for example In cell Z1 =or(A1="A",A1="D",A1="Z") then copy formula down column Z to last row of data. Then autofilter column Z. -- joel ------------------------------------------------------------------------ joel's Profile: 229 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=160741 Microsoft Office Help |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I specify more than 2 criteria in AutoFilter
You could add another helper column that contains a formula that evaluates to
true/false. Then filter on that column. The formula could be as simple as something like: =or(a2="hi",a2="bye",a2="there") or this equivalent: =or(a2={"hi","bye","there"}) Or it could be as complex as you need. Or you could learn about advanced filtering and criteria ranges. I'd start at Debra Dalgleish's site: http://contextures.com/xladvfilter01.html Felix_Jiang wrote: Seems the AutoFilter can have at most 2 criteria. I do have a need to have 3 or more criteria to filter out a column of strings. How can I accomplish this? Thanks! Felix -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I specify more than 2 criteria in AutoFilter
Use a helper column or switch to 2007. 2007 has a much improved AutoFilter.
-- Gary''s Student - gsnu200909 "Felix_Jiang" wrote: Seems the AutoFilter can have at most 2 criteria. I do have a need to have 3 or more criteria to filter out a column of strings. How can I accomplish this? Thanks! Felix |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
autofilter criteria | Excel Programming | |||
autofilter criteria | Excel Programming | |||
Selection.AutoFilter Field / Criteria = criteria sometimes non-existing on worksheet | Excel Programming | |||
Autofilter criteria not yet known | Excel Programming | |||
AutoFilter Criteria VBA | Excel Programming |