moving average without multi-row-formula Tool

Question

I would like to get a moving average like the sample data.
In addition, the average you want to use is calculated using small numbers such as 1 and 2 to large numbers such as 100 and 200.

The multi-low formula can only run + -3 lines on average, so I'd like to know how to do that.
Also, I want to average a large number of data in multiple lines like attached data, so please tell me how to do that.

Thank you very much

Moving average_Sampledata.xlsx

fmvizcaino · Accepted Answer

Hi @SaoriYamguchi ,

Nice challenge.

Take a look and let me know if this works for you. I've tried to describe every step to make it clear what I've done.

Best,

Fernando Vizcaino

Qiu · Accepted Answer

@SaoriYamguchi 
Try to make it a bit dynamic.

So you need to define the moving average number (How many rows) as input, then macro would do the rest.

But if you want exactly the same as your Excel, we need think more.