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
|