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!