max and min help.

[Soccerboy83]

So i am currently trying to write a formula that can help me find the max and
min values from a list of data. what i have is three columns
Example
Date Max Temp. Min Temp.
1/1/09 95 65
1/1/09 98 63
1/1/09 87 54
...........
12/31/09 78 37
12/31/09 86 37
12/31/09 54 41
What i want to do is specify a date and have it give me the max and min of
the Max Temp. and the max and min of Min Temp. Each day has over 48 readings.
So basically i will ask, that i want the max reading for the Max Temp. for
all occurences that happened on 1/1/09. this may be easy but after along day
at work my brain is fried.

 

[Matthewjd]

Easy way is to add two extra columns for max and min functions. The use a
lookup function based on the date you specify.

Probably a better way, but that'll work.

 

[Don Guillett]

Where col a has the date and col b the temp and d7 the desired date
=MAX(IF((A10:A12=D7),B10:B12))

 

[Soccerboy83]

It does not work, Here is my formula,
=MAX(IF(('Collected Data'!$A$4:$A$65500=B12),'Collected
Data'!$H$4:$H$65500)), where Column A is my date range,B is my specified
date, and column H is my Temp. data.
When i do this, it gives me the maximum value for the entire column, not the
specified date. What am i doing wrong.

 

[Don Guillett]

Did you ARRAY enter with ctrl+shift+enter
Do you have properly formatted dates in the column AND in the request cell?

If desired, send your file to my address below along with this msg and
a clear explanation of what you want and before/after examples.

Can't look tonite

 

[Soccerboy83]

It worked, i forgot to format the dates into dates, i told you my brain was
fried. Thanks for your help. Now i can sleep easy tonight.