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

@PKAnExcelExpert

9 ай бұрын

Thanks🙏

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)

Thank you so much Sir

@PKAnExcelExpert

9 ай бұрын

Most welcome🙏

class , keep it up, thank you for sharing

@PKAnExcelExpert

9 ай бұрын

Most welcome🙏

👍👍👍👍Thank you PK!!!

@PKAnExcelExpert

9 ай бұрын

Most welcome🙏

Hi sir ! Your videos are really simple yet useful.

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

@PKAnExcelExpert

9 ай бұрын

Most welcome🙏

Excellent!

@PKAnExcelExpert

7 ай бұрын

Many thanks!

As always awesome work - thank you !

@PKAnExcelExpert

9 ай бұрын

Most welcome🙏

Super amazing video 📹 👏 Thank u PK

@PKAnExcelExpert

9 ай бұрын

Most welcome🙏

Thanks for the share.

@PKAnExcelExpert

9 ай бұрын

Most welcome🙏

Thank you PK

@PKAnExcelExpert

9 ай бұрын

Most welcome🙏

👍 nice

@PKAnExcelExpert

9 ай бұрын

Thanks

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! 👍🙏

PK you are awasom

@PKAnExcelExpert

9 ай бұрын

Thanks🙏

Excellent sir💐💐💐

@PKAnExcelExpert

9 ай бұрын

Thanks🙏

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.

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?

👍

@PKAnExcelExpert

5 ай бұрын

Thanks

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

9 ай бұрын

Thanks for the idea! Will try.

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.

how to get the formula for the horizon data flow

How to calculate the zigzag indicator?

1st comment Give me some gift😂

@PKAnExcelExpert

9 ай бұрын

Thanks a lot 👍👍👍

Love it! Let's be friends?

@PKAnExcelExpert

8 ай бұрын

Thanks and sure