Filtering Spreadsheets Using Multivariable "Or" Statements
 

Hey everybody,

I came across this site and have a question I just haven't been able to get figure out. I've also attached the spreadsheet I was looking at, so you have some context. It's a tiny spreadsheet, just trying to figure out in principle how I accomplish something. So here is my problem:

I want to be able to create a spreadsheet that will allow me to input data as to whether or not a specific company produces a common, specific product. As you'll see in my spreadsheet I've simply labeled them products 1-4. What I'd love to be able to do is have the input each company be a simple check mark, in the same vain as the picture embedded in the spreadsheet. However, I understand if that part is not possible, and it needs to be an input (I used a simple "y" to denote yes). What I would then want to be able to do is have a drop down menu that would allow me to filter the results as if the menu is one giant "or" statement. So for example I would want to be able to filter the results by companies that produce product 1 and/or product 4. Right now I've only been able to do "and" statements.

I appreciate any help you might be able to offer me! Thanks in advance and let me know if my question isn't clear enough.

Ben