Using MIN & MAX

J

Jack Deuce

I have two columns, A being dates and B being values. How can I
display from those two columns the minimum amount and the maximum
amounts in separate cells at the bottom of the list? IOW, I'd like to
see which date (from the column A) has the maximum and minimum value.

Thanks in advance..
 
J

JBeaucaire

First, I would suggest you NOT put this in the same column as the data you're
evaluating since you can evaluate the entire column by staying out of it.

Column A = dates
Column B = values

E1 =MIN(B:B)
E2 =MAX(B:B)

F1 =INDEX(A:A,MATCH(E1,B:B,0))
F2 =INDEX(A:A,MATCH(E2,B:B,0))
 
J

Jacob Skaria

Minimum value and date
C1 = MIN(B1:B1000)
D1 = INDEX(A1:A1000,MATCH(C1,B1:B1000,0),0)

Max value and date
C2 = MAX(B1:B1000)
D2 = INDEX(A1:A1000,MATCH(C2,B1:B1000,0),0)


If this post helps click Yes
 
Top