Filtering based on multiple properties/criteria

[therockerz]

Hi all,

An urgent query and any help will be greatly appreciated.

I have a spreadsheet (with data) with the following structure:

Name	Is it white?	Is it edible?	Is it cheap?	Is it solid?
Apple	0	1	1	1
Milk	1	1	1	0
Car	0	0	0	1
Moon	1	0	0	1

<tbody>
</tbody>

Apologies for the poor example data.

What I need it to do is based on a checkbox input where user will select whether they want to see white/cheap/edible/solid or a combination, and this list will be filtered based on that.

For example, user selects white and/or edible - the result on a different page should be:

Name

Apple

Milk

Moon

<tbody>
</tbody>

Any thoughts on how I can achieve this? In my example, there are just three criteria, but in my work sheet I have around 200 criteria, so advanced filter with "OR" structure would take up too many rows.

Any solution whether VBA/not would be really appreciated!

Thanks.

 

[therockerz]

Thank you so much!

 

[RoryA]

Glad to help