Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I find the greatest possible sum within 12 months? A newbie... | Excel Worksheet Functions | |||
Picking out a Period, in relation to certain cells | Excel Worksheet Functions | |||
SUM a range of sales based on month | Excel Worksheet Functions | |||
Average starting with first month | Excel Discussion (Misc queries) | |||
Working days left in the month compared to previous months | Excel Worksheet Functions |