Best 3 Consecutive Months
Hi,
It may be possible in a single formula but nothing springs to mind so here's
another solution.
Say your data are in column A. Put this in (say) B1 and drag down
=SUM(A1:A3)
You now have a sum of every set of 3 consecutive cell so simply max and min
this new range to get the highest and lowest values for 3 consecutive months.
--
Mike
When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
"Desoto" wrote:
I have 10 years worth of monthly data and need to determine the best (or
worst) three consecutive months for benchmarking purposes. How do I write a
formula that provides me the value of the highest (or lowest) value for three
consecutive months (perhaps array formula?). I want to avoid at all cost
adding another column of data to the worksheet that provides a running three
month average and then utilizing the MAX or MIN function to determine the
value.
Thanks in advance
Rachel
|