Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Get MAX value according to TRUE/FALSE flag
Hi all,
This is fairly simple yet I am novice on this worksheetfunction using possibly array version of that. A B C 1 TRUE TRUE FALSE 2 12 14 16 I would like to get maximum number of the first two in Row 2 above. Because the third one is flagged as FALSE (C1) I don't want to include 16 (C2) as part of MAX calculation. I was thinking of "=MAX(A1*A2,B1*B2,C1*C2)" in array formula but in vain... Any idea? Thanks for your brain time. --- Tetsuya Oguma, Singapore |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comment Flag Color | Excel Discussion (Misc queries) | |||
retain 'update remote reference' flag | Excel Worksheet Functions | |||
Want to change the color of a true/false logical statement with i. | Excel Worksheet Functions | |||
replacing TRUE/FALSE | New Users to Excel | |||
replacing TRUE/FALSE | New Users to Excel |