I wanna associate average with a changing number which determines how many
numbers in group to calculate a average.
For example, in an excel sheet, I have one column full of prices data, let's
say, Column A. And in the cell D5, there is a initial number: 5 which means
in column A, we should calculate average mean for every five continuous
prices (like moving average in Finance). If I change Cell D5 into 10, I want
the data column A was averaged in every 10 prices.
That's is to say, by associated Column A and the cell D5, I may be able to
use solver to get some valuable information.
I hope I explain the problem clearly. I am very in a hurry to know the
answer. Thank you.