Hi, someone asked me at work if it's possible to set up multiple advanced filtering conditions, but only to apply them u
For instance, say I had a table with the headers Fruit and Colour and Country
In advanced filtering, I set out my conditions:
1) Fruit must be an apple or orange
2) Fruit must be red
3) Fruit must be from Australia
Say nothing matches condition 1), so it then looks at condition 2. It finds red fruit, so it ONLY FILTERS THE TABLE BASED ON THIS, even though there is non-red Australian fruit in the table.
ie - it has stopped filtering as a true condition was found.
I have no idea if this can be done through Advanced Filtering, a formula or something else I don't know about - can anyone help?
Thanks!!
For instance, say I had a table with the headers Fruit and Colour and Country
In advanced filtering, I set out my conditions:
1) Fruit must be an apple or orange
2) Fruit must be red
3) Fruit must be from Australia
Say nothing matches condition 1), so it then looks at condition 2. It finds red fruit, so it ONLY FILTERS THE TABLE BASED ON THIS, even though there is non-red Australian fruit in the table.
ie - it has stopped filtering as a true condition was found.
I have no idea if this can be done through Advanced Filtering, a formula or something else I don't know about - can anyone help?
Thanks!!