Excel - Checkbox filtering?

[Pete1989]

Ok, so I'm not sure exactly what the best term is for what I'm looking for - if anyone could assist that would be great.

So I need to set up a spreadsheet that has a list of products and characteristics to go along with them.

Then I need checkboxes so I tick characteristics A,B & D and it filters down to show what products match those characteristics.

Any ideas?

 

[Mynight]

http://www.pcworld.com/article/2042382/add-checkboxes-to-an-excel-spreadsheet.html

(Sorry assuming you don't know how to add checkboxes)

Allocate a set of cells for your checkbox search strings with checkboxes next to said strings. Set the checkbox defaults (right click properties on CB).



Then I would assign a cell to display results and input a formula using an "if/and/or" statement to check the checkbox states and assign a "search" function based on outcome.

There's probably a simpler way.

Edit: not near pc at the moment I can have a crack at the function tommorow for you if you want.

 

[Pete1989]

Thanks. I'll have a go today and get back to you.

 

[Pete1989]

Think I've got it. Thanks a lot.

 

[Mynight]

No worries. I imagine it to be a fairly long equation

I have little experience with excel but it seems to follow suit of php/sql queries so I can surmise the functions somewhat.

Always about if you get stuck.