| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Advanced filtering how do you define a cell as blank | Excel Discussion (Misc queries) | |||
| Filtering slows down a macro | Excel Worksheet Functions | |||
| Advance filtering with multiple conditons | Excel Discussion (Misc queries) | |||
| Row filtering based on input box entry (column heading) | Excel Worksheet Functions | |||
| trouble filtering a list. Why isn't column filtering? | Excel Worksheet Functions | |||
Linear Mode
