More Criteria for AutoFilter

  • Thread starter Thread starter Murtaza
  • Start date Start date
M

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
 
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??
 
Only need for one column.

Frank Kabel said:
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??
Click to expand...
 
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.
 
Back
Top