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
|