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 |
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 |
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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 01:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com