View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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