Excel formula: select value in column if condition in 2nd col met
 

I want to construct a formula to select the largest value in a column of data
for only data that meets a condition in a second column. Specifically I want
to select the largest value in a column of data for only values that are
specified "WIN" in a second column.
Example:
column 1: cell A1 = 5, cell A2 = 10, cell A3 = 20
column 2: cell B1 = WIN, cell B2 = loss, cell B3 = WIN
So formula should give 20 as the result (eg largest WIN value).

I have pored over help guides and on-line references but can't do it, so if
anyone can help....pleease!

Excel formula: select value in column if condition in 2nd col met
 

Hi
try the following array formula (entered with cTRL+SHIFT+ENTER):
=MAX(IF(B1.B100="WIN",A1:A100))

--
Regards
Frank Kabel
Frankfurt, Germany

"Rapidcat" schrieb im Newsbeitrag
...
I want to construct a formula to select the largest value in a column
of data
for only data that meets a condition in a second column. Specifically
I want
to select the largest value in a column of data for only values that
are
specified "WIN" in a second column.
Example:
column 1: cell A1 = 5, cell A2 = 10, cell A3 = 20
column 2: cell B1 = WIN, cell B2 = loss, cell B3 = WIN
So formula should give 20 as the result (eg largest WIN value).

I have pored over help guides and on-line references but can't do it,
so if
anyone can help....pleease!

Excel formula: select value in column if condition in 2nd col met
 

Thanks Frank - that worked perfectly.

I appreciate you taking the time to help me.

Prost!

David Thomason
Melbourne, Australia
-----Original Message-----
Hi
try the following array formula (entered with
cTRL+SHIFT+ENTER):
=MAX(IF(B1.B100="WIN",A1:A100))

--
Regards
Frank Kabel
Frankfurt, Germany

"Rapidcat" schrieb
im Newsbeitrag
news:B0536107-823D-4D0D-B68C-
...
I want to construct a formula to select the largest
value in a column
of data
for only data that meets a condition in a second
column. Specifically
I want
to select the largest value in a column of data for
only values that
are
specified "WIN" in a second column.
Example:
column 1: cell A1 = 5, cell A2 = 10, cell A3 = 20
column 2: cell B1 = WIN, cell B2 = loss, cell B3 = WIN
So formula should give 20 as the result (eg largest
WIN value).

I have pored over help guides and on-line references
but can't do it,
so if
anyone can help....pleease!


.