|
max and min help.
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. |
max and min help.
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. "Soccerboy83" wrote: 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. |
max and min help.
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. |
max and min help.
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. |
max and min help.
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. |
| All times are GMT +1. The time now is 04:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com