Just to save typing:
=OR(D2={"A","B","C"})

well, it's easier to add stuff, too.

Debra Dalgleish wrote:

Or, to check for multiple criteria in the same column, you could use a
formula like:

=OR(D2="A",D2="B",D2="C")

Or list the multiple criteria on the worksheet, then check if the value
in the current row is in the list, e.g.:

=COUNTIF($K$2:$K$4,D2)0

With either formula, filter the helper column for TRUE.

Dave Peterson wrote:
Along with Norman's suggestions, you could use a helper column of cells and put
a formula that includes all your criteria:

=and(a2="hi there",b219,c2<date(2004,11,12),d2<"")

Then filter to show the true/false.



Glen Mettler wrote:

Is it possible to conduct an autofilter with more than 2 criteria?

Glen



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

--

Dave Peterson