View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim Brass Jim Brass is offline
external usenet poster
 
Posts: 12
Default Calculating Max, Min, Ave etc of a large region

I have the following task:
1900 1901 1902 out til 2005
Jan 1
Jan 2
Jan 3
down to Dec 31

I want to creat a table for the Max, Min, Ave High, etc. for each month of
each year.
For example:
1900 1901 1902 etc
Jan
Feb

Can I use some array formula that will be copiable that will save me making
up hundreds of formulas?

Thanks