Autofilter
 

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

Glen

Autofilter
 

Hi Glen,

You would need to use the Advanced Filter or, alternatively, you can
download a free EasyFilter add-in from Ron de Bruin at:

http://www.rondebruin.nl/easyfilter.htm

The add-in allows up to 5 criteria, I believe.

---
Regards,
Norman



"Glen Mettler" wrote in message
...
Is it possible to conduct an autofilter with more than 2 criteria?

Glen

Autofilter
 

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

--

Dave Peterson

Autofilter
 

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

Autofilter
 

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