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.

"Don Guillett" wrote:

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Soccerboy83" wrote in message
...
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" wrote:

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Soccerboy83" wrote in message
...
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.