Using MIN & MAX
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
---------------
Jacob Skaria
"Jack Deuce" wrote:
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..
|