filteren

[anouch]

Hoe kan ik filteren op meer dan 3 criteria?
Dank U.
Anouch

 

[Dave Peterson]

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.)

 

[Debra Dalgleish]

To filter by more than 3 criteria, you can use an Advanced Filter. There
are instructions here:

http://www.contextures.com/xladvfilter01.html