LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Highest 12-Month Period Average Over Range of Months

I need to know if a formula can be constructed that will return the highest
consecutive twelve-month average over a range of months.

Example:
Assume cells A1..A14 represent a single month and contain the following
values.
1, 6, 3, 8, 2, 9, 12, 3, 6, 2, 6, 9, 9, 4

In this example, there are 3 consecutive twelve-month periods, A1..A12,
A2..A13 and A3..A14. The average of A1..A12 = 5.58, A2..A13 = 6.25, and
A3..A14 = 6.08. I want a formula that will return the highest average of the
three, 6.25.

Thanks in advance for any assistance.
-Mark


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I find the greatest possible sum within 12 months? A newbie... [email protected] Excel Worksheet Functions 17 October 1st 06 11:49 PM
Picking out a Period, in relation to certain cells vikki1603 Excel Worksheet Functions 6 August 29th 06 03:10 PM
SUM a range of sales based on month Manos Excel Worksheet Functions 9 May 8th 06 10:30 AM
Average starting with first month Jim Excel Discussion (Misc queries) 7 October 29th 05 12:48 PM
Working days left in the month compared to previous months qwopzxnm Excel Worksheet Functions 8 October 24th 05 08:00 PM


All times are GMT +1. The time now is 04:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"