• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Multiple filters in columns?

H

Hugo huijer

Member
Hi Chandoo!

Is it possible to have mutliple filters in a column? This would mean that the filter would be assigned to a specific range, allowing another filter to be made below that area, to filter another range. Is this possible?

Thanks
 
Hi Hugo ,

I think this is not possible using the in-built AutoFilter or AdvancedFilter commands ; however , using loops , you can hide rows based on criteria , so that the effect will be the same.

Narayan
 
Hi HUgo..

In short NO..
but.. if you create a helper column.. with perfect condition, and return TRUE / FALSE..

something like If row # is less than 15 and value > 50 then TRUE
and if row # is greater than 15 and value < 50 then TRUE.
then you can apply filter in the helper column(you can avoid helper column by Advance Filter but a Helper cell is required).. only TRUE..
 
Thanks for your quick replies! The community of Chandoo is amazing!

I was afraid of a negative answer.

To clearify:

If I have one column containing 2 lists: one list of fruits and one list of vegetables. I want filters above both those lists, while in the same column.

I guess this is not possible without the use of many detours?
 
Hi Hugo ,

This is possible using a workaround ; if the number of different values in one column , say C , are not many , you can have checkboxes , and depending on which checkboxes are checked , the relevant rows can be hidden or displayed.

Narayan
 
That's allright. I think I can live with just one row of filters. I don't to overcomplicate my sheet for just a filter. Thanks for the help though!
 
TABLE if you take the time to put some data into your empty sheet tables, then we can show you how to apply multi filter to any or all columns, you must do some of the work
 

Attachments

@Debraj

Wow, that looks just like the thing I need... I must say, I'm far from a Excel Ninja (hope to be one some day ;)), and I have not used that function before.

I have one questions. Is this function also usable when the size of the table can grow? A userform will supply the table with data, and as this happen, the number of rows will increase. Is the TABLE function able to accommodate this growth?

Thanks a lot!
 
I have just tried it, and when I tried to insert another row within my table, Excel wouldn't allow it. Is there any way around this?
 
Tables will grow auto it you hit the tab key when you are in the last bottom right cell of the table this will auto increase the table and its fields
 
You must log in or register to reply here.
Back
Top