Find largest value in column with 2 criteria

  • Thread starter Thread starter Charles Fish
  • Start date Start date
C

Charles Fish

Greetings.

I have a large data set
Let's say it's A1:C999

Each cell in Col A has a number 1 to 9.
Each cell in Col B has a number, unrelated to what is in Col A.
Each cell in Col C has a formula which either produces text or "".

How can I retrieve the largest value in Col B for which these two criteria are met:
Col A in the same row is > 2 and < 9
Col C in the same row = ""

Thanks in advance,
Charles
 
Hi Charles,

Am Mon, 17 Nov 2014 15:41:22 -0800 (PST) schrieb Charles Fish:
Each cell in Col A has a number 1 to 9.
Each cell in Col B has a number, unrelated to what is in Col A.
Each cell in Col C has a formula which either produces text or "".
Click to expand...

try:
=MAX(IF((A1:A999>2)*(A1:A999<9)*(C1:C999=""),B1:B999))
and insert the array formula with CTRL+Shift+Enter


Regards
Claus B.
 
Back
Top