Dynamic Moving Average in Excel: Mastering the AVERAGE + OFFSET Combo

[@nsanch0181]

Thank you PK for the great video on moving average. Very useful and I learn so much from you. I like how you used the If and counta to show blank less than Interval.
=IF(COUNTA($D$6:D6)

[@yazid6058]

Every day I learn something useful from you. I wish you success

[@PKAnExcelExpert]

Thanks🙏

[@rajeshmajumdar4999]

👍👍👍👍Thank you PK!!!

[@PKAnExcelExpert]

Most welcome🙏

[@unnikrishnansanthosh]

class , keep it up, thank you for sharing

[@PKAnExcelExpert]

Most welcome🙏

[@nadermounir8228]

Super amazing video 📹 👏 Thank u PK

[@PKAnExcelExpert]

Most welcome🙏

[@gurucool80]

Superb PK.... as usual your ideas and Excel suggestions are very useful and helpful in day in day out. Thanks a lot

[@PKAnExcelExpert]

Most welcome🙏

[@timesavertricks]

Hi sir ! Your videos are really simple yet useful.

[@pandharinathjoshi6565]

Excellent sir💐💐💐

[@PKAnExcelExpert]

Thanks🙏

[@pedromartinez1165]

As always awesome work - thank you !

[@PKAnExcelExpert]

Most welcome🙏

[@girishpadshala9689]

Thank you PK

[@PKAnExcelExpert]

Most welcome🙏

[@SyedMuzammilMahasanShahi]

Thanks for the share.

[@PKAnExcelExpert]

Most welcome🙏

[@karthick2254]

👍 nice

[@PKAnExcelExpert]

Thanks

[@setyoufree2726]

Excellent!

[@PKAnExcelExpert]

Many thanks!

[@akhilrastogi6611]

PK you are awasom

[@PKAnExcelExpert]

Thanks🙏

[@VisuLytics]

thanks PK. Very useful video. I also wanted to ask you that which utility you use for to zoom IN and OUT during making your videos. I would appreciate your response.

[@southisacknova]

Thank you so much Sir

[@PKAnExcelExpert]

Most welcome🙏

[@evgeny6971]

Please help me to understand - before we use COUNTA, why AVERAGE(OFFSET(B6,,,Interval*-1)) returns correct numbers in C6-C8 cells?
As I understand, in C6 OFFSET should return B2:B6 range to AVERAGE, but it returns 26 back. Why is not an error there when we are trying to calculate AVERAGE in a range of different data types?
PS - thank you very much for your tips, they are awesome! 👍🙏

[@tier1athlete829]

Can I add new column continually between A & B to keep adding in new data & keep calculating the rolling average within a single row to the left of the rolling average column?

[@deepak.pareek]

how to get the formula for the horizon data flow

[@himanishghosh5149]

Sir the backward count (negative value) is not working in google sheet. Any way out for that?

[@hammeedabdo.82]

How to calculate the zigzag indicator?

[@timesavertricks]

I have a query regarding Data Validation using List method
I have more than 15 upto 30 to 50 names in listing.
Is there any easy way to select the name from list
Instead of open list and scroll to search name.

[@benjieh.9680]

Good day sir.. Can you make a "Document tracking system"? like a search concept that can see the history of what happened in the previous status of a document (without using VBA). I hope you notice my comment. Thank in advance, more power to your channel.

[@PKAnExcelExpert]

Thanks for the idea! Will try.

[@yulinliu850]

👍

[@PKAnExcelExpert]

Thanks

[@manojraja3258]

1st comment
Give me some gift😂

[@PKAnExcelExpert]

Thanks a lot 👍👍👍

[@cecilia_mackie]

Love it! Let's be friends?

[@PKAnExcelExpert]

Thanks and sure