D
Dave Hunt
Hi folks,
Extention of a question I asked yesterday (thanks Biff!).
I have two columns. Column 1 contains the letters A, B,
C, or D. Column 2 contains a numeric value (1 - 36). I am
trying to find the max (and min) of column 2 when the
value in column 1 is "A" (or one of the other letters).
Simple example:
col1 col2
A 2
D 36
A 18
C 20
A 24 << col1 = "A" and max value
B 8
A 0
I've tried =SumProduct(A1:A6="A")*(MAX(B1:B6) but this
is just giving me zero (false, I guess).
The answer should be 24 in this case. Any idea how to
modify or take a different approach to get the max value?
Any help is greatly appreciated. Thanks in advance. This
is a great forum.
Dave Hunt
Extention of a question I asked yesterday (thanks Biff!).
I have two columns. Column 1 contains the letters A, B,
C, or D. Column 2 contains a numeric value (1 - 36). I am
trying to find the max (and min) of column 2 when the
value in column 1 is "A" (or one of the other letters).
Simple example:
col1 col2
A 2
D 36
A 18
C 20
A 24 << col1 = "A" and max value
B 8
A 0
I've tried =SumProduct(A1:A6="A")*(MAX(B1:B6) but this
is just giving me zero (false, I guess).
The answer should be 24 in this case. Any idea how to
modify or take a different approach to get the max value?
Any help is greatly appreciated. Thanks in advance. This
is a great forum.
Dave Hunt