Posted to microsoft.public.excel.misc
|
|
Matrix selection
Two more solutions:
http://img35.imageshack.us/img35/2750/nonamecr.png
Micky
"Marco Rod" wrote:
Hello,
I have a problem and I need a solution that I'm not finding out. I need a
formula that give me a specific value in a matrix (under the condition of
column and row).
Example: I have the matrix described below. I need a formula that gives me
how many keybords has room 1. Of course that the formula must allow me to
change the conditions of the serach.
Advisors PC Mouse keybord
Room 1 20 30 40
Room 2 30 67 90
Thanks in Advance for your support
Regards
Marco
|