max value from multiple rows of similar information

  • Thread starter Thread starter Karesel
  • Start date Start date
K

Karesel

- A B C D
1 BROOK PINE 5/25 47
2 BROOK PINE 5/26 21
3 BROOK PINE 5/27 33
4 BROOK PINE 5/28 49
5 BROOK PINE 5/29 19
6 WHITE SNOW 5/25 23
7 WHITE SNOW 5/26 21
8 WHITE SNOW 5/27 77
9 WHITE SNOW 5/28 46
10 WHITE SNOW 5/29 22

From the above I want obtain the maximum value from column D but only from
rows that match “WHITE†in column A which should be the 77 from cell D8.

Thanks in advance
 
Try this array formula** :

=MAX(IF(A1:A10="white",D1:D10))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.
 
Is there a way to get the formula to pick up the cell with "WHITE" in it,
rather than entering "white" in the formula itself?

Again, thanks in advance...
 
Sure, just replace "white" with the cell reference:

F1 = white

=MAX(IF(A1:A10=F1,D1:D10))

Don't forget, array entered!
 
Thanks so much it's working...

T. Valko said:
Sure, just replace "white" with the cell reference:

F1 = white

=MAX(IF(A1:A10=F1,D1:D10))

Don't forget, array entered!
Click to expand...
 
Back
Top