| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filters
Can I have more than one filter if I have several categories on a sheet that
i want different filters for, if so how. Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Filters
Are you familiar with the Data -- Filter option?
Are you trying to filter more than 1 column? Have you tried the "custom" filter? Am I interpreting your question correctly? "Muskrat24" wrote: Can I have more than one filter if I have several categories on a sheet that i want different filters for, if so how. Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Filters
no I have multiple categories on a sheet with several selections for each and I want a filter for each category. The only way that i can think of to do this is to have a filter for each category but it will only let me have 1 filter per sheet. Is there a way i can have more than 1 filter? "Elgee" wrote: Are you familiar with the Data -- Filter option? Are you trying to filter more than 1 column? Have you tried the "custom" filter? Am I interpreting your question correctly? "Muskrat24" wrote: Can I have more than one filter if I have several categories on a sheet that i want different filters for, if so how. Thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Filters
I believe you can have more than one advanced filter on a sheet.
You can't have more than one autofilter section. Gord Dibben MS Excel MVP On Thu, 18 Jun 2009 13:53:01 -0700, Muskrat24 wrote: no I have multiple categories on a sheet with several selections for each and I want a filter for each category. The only way that i can think of to do this is to have a filter for each category but it will only let me have 1 filter per sheet. Is there a way i can have more than 1 filter? "Elgee" wrote: Are you familiar with the Data -- Filter option? Are you trying to filter more than 1 column? Have you tried the "custom" filter? Am I interpreting your question correctly? "Muskrat24" wrote: Can I have more than one filter if I have several categories on a sheet that i want different filters for, if so how. Thanks |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Filters
how do i use an advanced filter?
"Gord Dibben" wrote: I believe you can have more than one advanced filter on a sheet. You can't have more than one autofilter section. Gord Dibben MS Excel MVP On Thu, 18 Jun 2009 13:53:01 -0700, Muskrat24 wrote: no I have multiple categories on a sheet with several selections for each and I want a filter for each category. The only way that i can think of to do this is to have a filter for each category but it will only let me have 1 filter per sheet. Is there a way i can have more than 1 filter? "Elgee" wrote: Are you familiar with the Data -- Filter option? Are you trying to filter more than 1 column? Have you tried the "custom" filter? Am I interpreting your question correctly? "Muskrat24" wrote: Can I have more than one filter if I have several categories on a sheet that i want different filters for, if so how. Thanks |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Filters
You could start with Excel help on advanced filter.
Or see Debra Dalglesih's site for instructions on the basics. http://www.contextures.on.ca/xladvfilter01.html Gord On Thu, 18 Jun 2009 14:32:02 -0700, Muskrat24 wrote: how do i use an advanced filter? "Gord Dibben" wrote: I believe you can have more than one advanced filter on a sheet. You can't have more than one autofilter section. Gord Dibben MS Excel MVP On Thu, 18 Jun 2009 13:53:01 -0700, Muskrat24 wrote: no I have multiple categories on a sheet with several selections for each and I want a filter for each category. The only way that i can think of to do this is to have a filter for each category but it will only let me have 1 filter per sheet. Is there a way i can have more than 1 filter? "Elgee" wrote: Are you familiar with the Data -- Filter option? Are you trying to filter more than 1 column? Have you tried the "custom" filter? Am I interpreting your question correctly? "Muskrat24" wrote: Can I have more than one filter if I have several categories on a sheet that i want different filters for, if so how. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table filters, especially DATE filters | Excel Worksheet Functions | |||
| Filters | New Users to Excel | |||
| How to copy with filters but not copy the filters in the middle? | Excel Discussion (Misc queries) | |||
| Filters, Subtotal & Intacted Results after the filters' Removal | Excel Discussion (Misc queries) | |||
| Filters | Excel Discussion (Misc queries) | |||
Linear Mode
