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

G

Guest

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!
 
F

Frank Kabel

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

David Thomason

Thanks Frank - that worked perfectly.

I appreciate you taking the time to help me.

Prost!

David Thomason
Melbourne, Australia
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF(AND(Complex Formula in Error in data import before I process it 8
Find largest value in column with 2 criteria 1
Find first value in column with formulas 3
Populate a cell if values in cell 1 and cell 2 match cell 3 and 4 1
Marco that will run if the condition met 2 1
Executing Part Of Macro Only On Cells Meeting A Condition 2
new formula after condition met 2
Formula appearing as Value in Formula Bar 1

Top