Autofilter

[Glen Mettler]

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

Glen

 

[Norman Jones]

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.

 

[Dave Peterson]

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",b2>19,c2<date(2004,11,12),d2<>"")

Then filter to show the true/false.

 

[Debra Dalgleish]

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]

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

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