How use filtering

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Cowtoon - 23 Jan 2007 17:05 GMT

I want the use the filtering feature but am not sure how to use it.
I want to use two criteria in my filter ... is this an option. The auto
filter allows for one criteria, but need two.
Would appreciate detailed help.
Thanks.

Reply to this Message

George Gee - 23 Jan 2007 17:13 GMT

If you are using autofilter, click on the down arrow
in the column that you wish to filter, and click "Custom".
Fill in the boxes, is this what you want?

George Gee

>I want the use the filtering feature but am not sure how to use it.
> I want to use two criteria in my filter ... is this an option. The auto
> filter allows for one criteria, but need two.
> Would appreciate detailed help.
> Thanks.

Reply to this Message

Pete_UK - 23 Jan 2007 17:31 GMT

You can use two criteria in an autofilter if you make use of Custom ...

The two criteria can be linked by AND or OR.

Hope this helps.

Pete

> I want the use the filtering feature but am not sure how to use it.
> I want to use two criteria in my filter ... is this an option. The auto
> filter allows for one criteria, but need two.
> Would appreciate detailed help.
> Thanks.

Reply to this Message