Excellent explanation Alan. It is also possible to obtain the results for all periods using Add-In Moving Average. This will create a column of results obtaining the moving average of 7 days for each date (if there are at least 7 previous dates). Thank you!
Sir please make a video , How to send multiple email from outlook with attachment through Excel showing the sending status of the that email on the second sheet with timestamp & Date by using Vba
i have some probably is a basic formula but I couldn't fine a way, I want get the average and I am using this for example =sum ( E1:E2)/2 but in the next column I have to find the average but it will be 3 numbers so I use =sum(E1:E3)/3 and so on. as you can see I cannot copy a formula I have to type one everyday. any one can help me to create a formula to just copy down. thank you appreciate your help
When I insert a value in row15, it did not work as what you shown in video. seems the formula did not catch it. (as row15 is out of the range). Pls guide. Thanks.
The formula use the ROWS function on the Table. When you enter a value in row 15, the table expands dynamically and this change in height is picked up by the ROWS function. Just check the table expanded by looking for the blue right corner in the bottom right.
Excellent explanation Alan. It is also possible to obtain the results for all periods using Add-In Moving Average. This will create a column of results obtaining the moving average of 7 days for each date (if there are at least 7 previous dates). Thank you!
Thank you, Iván.
Sure, the Add-In is available. But formulas are customisable and fun 😂
A superb little trick, very useful, thanks Alan
Very welcome. Thank you, Mohideen.
Nice. I use COUNTA instead of rows. This allows me to use this function on a non table.
Awesome, yes COUNTA is another approach. You got to love tables though, Eli 😜
@@Computergaga Yup. Keep these vids coming. They're awesome and well made!
Thank you very much. Your comments are appreciated.
Could you give me full formula using COUNTA in case of this video?
=AVERAGE(OFFSET($B$2,COUNTA(B:B)-7,,7))
By formatting data as a table, it avoids using these entire column references. But this works also.
A video with exponential averages would be nice also. thanks.
You're welcome. Thank you for the suggestion.
Cool Straight Forward Formula...Thank You Alan :)
Thanks, Darryl.
Would you please help explaining calculating backward moving average ?
How would you still do this if you had multiple data points on the same date but less data point on another date?
Sir please make a video , How to send multiple email from outlook with attachment through Excel showing the sending status of the that email on the second sheet with timestamp & Date by using Vba
Loved it.
Great! Thank you, Azeem.
Great!
Thank you, Usman.
@@Computergaga welcome
i have some probably is a basic formula but I couldn't fine a way, I want get the average and I am using this for example =sum ( E1:E2)/2 but in the next column I have to find the average but it will be 3 numbers so I use =sum(E1:E3)/3 and so on. as you can see I cannot copy a formula I have to type one everyday. any one can help me to create a formula to just copy down.
thank you appreciate your help
When I insert a value in row15, it did not work as what you shown in video. seems the formula did not catch it. (as row15 is out of the range). Pls guide. Thanks.
The formula use the ROWS function on the Table. When you enter a value in row 15, the table expands dynamically and this change in height is picked up by the ROWS function.
Just check the table expanded by looking for the blue right corner in the bottom right.
Thanks for your reply. Without using table formatting, is there any way to expand the range dynamically?