D Dave Peterson Dec 11, 2003 #2 Is your question: How can I filter on more than 3 criteria? If yes, then if you're writing about data|filter|autofilter, I think that you'd ask about filtering on more than 2 criteria (per field/column). I just use a helper column and create a formula that will evaluate to true/false and then filter on that column. (Sometimes the formula will be small, sometimes it'll be more complex.)
Is your question: How can I filter on more than 3 criteria? If yes, then if you're writing about data|filter|autofilter, I think that you'd ask about filtering on more than 2 criteria (per field/column). I just use a helper column and create a formula that will evaluate to true/false and then filter on that column. (Sometimes the formula will be small, sometimes it'll be more complex.)
D Debra Dalgleish Dec 11, 2003 #3 To filter by more than 3 criteria, you can use an Advanced Filter. There are instructions here: http://www.contextures.com/xladvfilter01.html
To filter by more than 3 criteria, you can use an Advanced Filter. There are instructions here: http://www.contextures.com/xladvfilter01.html
