V
Victor Delta
I have a column of monthly figures to which I add the latest month's result
at the bottom. In the next column, I have a formula which, each month,
calculates the average monthly figure for the last 12 months.
I would like to change this to a weighted average - with 12 being the
weighting for last month, 11 for the previous month and so on. Clearly I
could create a formula to do this but is there an Excel function which
already does this please?
TIA
V
at the bottom. In the next column, I have a formula which, each month,
calculates the average monthly figure for the last 12 months.
I would like to change this to a weighted average - with 12 being the
weighting for last month, 11 for the previous month and so on. Clearly I
could create a formula to do this but is there an Excel function which
already does this please?
TIA
V