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.