ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   How use filtering (https://www.excelbanter.com/new-users-excel/127317-how-use-filtering.html)

Cowtoon

How use filtering
 
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.



George Gee

How use filtering
 
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


"Cowtoon" wrote in message
...
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.





Pete_UK

How use filtering
 
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

Cowtoon wrote:

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.




All times are GMT +1. The time now is 02:59 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com