More Criteria for AutoFilter

[Murtaza]

Can I define more criteria other than 2.

I have found only Criteria1 & Criteria2 Property in VB, but i need more to
define.

Please help

 

[Frank Kabel]

Hi
do you want do define more than two criteria for one column? or do you
want to have filter criteria for moren than two columns??

 

[Murtaza]

Only need for one column.

Hi
do you want do define more than two criteria for one column? or do you
want to have filter criteria for moren than two columns??

 

[Frank Kabel]

Hi
not possible (you can't do this manuall either)

 

[Debra Dalgleish]

If you need more criteria, you can use an Advanced Filter.

 

[Dave Peterson]

And if you're as skittish as I am about Data|Filter|advanced filter, then this
is what I do.

I add a helper column. I populate that with a formula that will return
Show/NoShow (true/false, 1/0, keepit/don'tkeepit).

Then I filter on that column.