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 :
And would get this behaviour :
It would be great if someone is able to help me
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 :
And would get this behaviour :
It would be great if someone is able to help me