moving average without multi-row-formula Tool

[SaoriYamguchi]

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

[fmvizcaino · Accepted solution]

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 solution]

@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.

[SaoriYamguchi]

@fmvizcaino @Qiu 

Thanks!

[Qiu]

@SaoriYamguchi 

Glad to help and thank you for the accept mark.