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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to find additional ranges outside of min, max, and average 2
Calculating Average, Count, Min & Max against a range of Values 0
How can i find the max value within a time range ased on two cells 6
Format column widths from one table to a separate table on same page 1
Calculating a Formula Subject to a Maximum and Minimum Value 2
Spread numbers by setting up a Min and Max 2
Calculating Max & Min in a negative numbes 6
How to use/create code in MS Word to calculate age? 0

Top