• 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.

Is it possible to apply successively several Advanced Filters?

benjamin bouret

New Member
Hi everyone,

I have a sheet with columns containing comma-separated values.

I need to filter them by value, thing that I am currently able to do using Advanced Filter.

However, I would like to be able to apply an Advanced Filter to a range that have already been filtered by Advanced Filter. (that is to say repeat an Advanced FIlter)

I noticed that this kind of filter is like a switch ON/OFF, then the only possible action after have filtered, is to remove this filter.

Has someone a solution to my problem?

Redirecting filter results in a new sheet is not a feasible option.

-> Another perfect solution would look like as following :

Using AutoFilters, I get this behaviour :

wjs8.jpg


And would get this behaviour :

pprs.jpg


It would be great if someone is able to help me :)
 
Hi,

Here is my workbook :)

Currently, as you can see, my filter macros are copying filtered data into a new sheet. I would like to find a solution enabling me to keep those in the same sheet.
 

Attachments

  • Statistiques_Onecub_App.xlsm
    336.4 KB · Views: 0
Back
Top