Averaging last 25 non zero values.
Hi,
Have a dynamic list of sales values and want to make several
calculations on them, most of which I can do myself.... However, I
want to find an average of the last 25 (non-zero) values without using
a macro is this possible??
Many thanks in advance,
Peter
|