Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding MIN, MAX, and average
Hey all I am having a problem finding a quick way to get the average, minimum and maximum for the data i have. attached is a sample of the data am working with. it will continue like this for each month of th year. I need to find average, Minimum, and Maximum as shown in th attached file for each month. The number of years may also change fo each station. Any help on this matter will be greatly appreciated. : +------------------------------------------------------------------- |Filename: sample data.doc |Download: http://www.excelforum.com/attachment.php?postid=2705 +------------------------------------------------------------------- -- jim hense ----------------------------------------------------------------------- jim hensen's Profile: http://www.excelforum.com/member.php...fo&userid=1515 View this thread: http://www.excelforum.com/showthread.php?threadid=26788 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding MIN, MAX, and average
Use Data=Subtotal
-- Regards, Tom Ogilvy "jim hensen" wrote in message ... Hey all I am having a problem finding a quick way to get the average, minimum, and maximum for the data i have. attached is a sample of the data i am working with. it will continue like this for each month of the year. I need to find average, Minimum, and Maximum as shown in the attached file for each month. The number of years may also change for each station. Any help on this matter will be greatly appreciated. :) +-------------------------------------------------------------------+ |Filename: sample data.doc | |Download: http://www.excelforum.com/attachment.php?postid=2705 | +-------------------------------------------------------------------+ -- jim hensen ------------------------------------------------------------------------ jim hensen's Profile: http://www.excelforum.com/member.php...o&userid=15155 View this thread: http://www.excelforum.com/showthread...hreadid=267886 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding Average of last 5 entries | Excel Worksheet Functions | |||
Finding the Average | Excel Discussion (Misc queries) | |||
I need help finding an average | Excel Discussion (Misc queries) | |||
Finding a count above average | Excel Worksheet Functions | |||
Finding the average time | Excel Worksheet Functions |