M
Manu887
Hey everybody,
I came across this site and have a question I just haven't been able t
get figure out. I've also attached the spreadsheet I was looking at, s
you have some context. It's a tiny spreadsheet, just trying to figur
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 inpu
data as to whether or not a specific company produces a common, specifi
product. As you'll see in my spreadsheet I've simply labeled the
products 1-4. What I'd love to be able to do is have the input eac
company be a simple check mark, in the same vain as the picture embedde
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
would then want to be able to do is have a drop down menu that woul
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 result
by companies that produce product 1 and/or product 4. Right now I'v
only been able to do "and" statements.
I appreciate any help you might be able to offer me! Thanks in advanc
and let me know if my question isn't clear enough.
Be
+-------------------------------------------------------------------
|Filename: Test.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=585
+-------------------------------------------------------------------
I came across this site and have a question I just haven't been able t
get figure out. I've also attached the spreadsheet I was looking at, s
you have some context. It's a tiny spreadsheet, just trying to figur
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 inpu
data as to whether or not a specific company produces a common, specifi
product. As you'll see in my spreadsheet I've simply labeled the
products 1-4. What I'd love to be able to do is have the input eac
company be a simple check mark, in the same vain as the picture embedde
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
would then want to be able to do is have a drop down menu that woul
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 result
by companies that produce product 1 and/or product 4. Right now I'v
only been able to do "and" statements.
I appreciate any help you might be able to offer me! Thanks in advanc
and let me know if my question isn't clear enough.
Be
+-------------------------------------------------------------------
|Filename: Test.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=585
+-------------------------------------------------------------------