#139

[@debdeepbhowmick7107]

sir, how to put this dynamic range into pivot table source location in google sheet, because i want to make pivot table dynamic in google sheet, I have used open range in pivot table source location but it also included all empty rows, can you suggest a better option?

[@shantisawaroopsharma877]

I learnt a lot from your videos. You understand the functions very deeply

[@SahaComputer]

Glad to hear that!

[@Schlaggonwaggon]

Can you do this, but for a chart? We enter sales volume data for many different regions weekly into a table, and want a chart that dynamically shows the previous 3 months of weekly sales volume. As it stands right now, we are manually updating the X axes, and it takes forever. Is there a solution here? I know you can do it in excel with the offset function, but does not work the same in Google sheets. Any help?

[@jwalk777778]

Thank you Saha for wonderful tutorial! I have a question, if you have another column “Date”, and say you like to know apples that sold in certain month, can you do that?

[@SahaComputer]

=SUMIFS(C2:C7,B2:B7,">="&A2,B2:B7,"

[@jwalk777778]

Awesome! Thank you so much!

[@SahaComputer]

You're welcome

[@composure7394]

Thanks a million

[@SahaComputer]

Thanks for the comment.

[@10shyam]

Thank you very much sir. You the best I got here what I was searching for.

[@SahaComputer]

Glad to hear that

[@tigerlilly6895]

Thank you, only issue is you misspelled quantity wrong in the dynamic range but cool to learn that you updated it just by spelling correctly in formula.

[@SahaComputer]

Thanks for your comment.

[@krishnatate4765]

Thank u sir

[@SahaComputer]

Welcome

[@mrigendraverma9631]

Very well explained indeed

[@SahaComputer]

Thanks for your comment.

[@firmanyuliansyahkurachman1987]

Thank you sir this is very helpful... i have a question for another case, how to make dynamic range for series in chart? I can't use "indirect function" for this case ... can you help me to make an example?

[@firmanyuliansyahkurachman1987]

especially for candlestick charts

[@SahaComputer]

First you create a table of that data and create candle chart. And whenever you add data into table, it will be visible in chart. So in this case table is the solution for dynamic range. Please subscribe & share our channel.

[@usmanahmad7758]

Great 🎉 I've question, can indirect function be added in name range?

[@ubnuday]

Hi Sir, thank you for providing the great demos. I have a query to solve in google sheet, Below is my usecase as follows I have five columns in a sheet (A,B,C,D,E) A - i kept some data (text) B and C columns will update the values(result) dynamically as per the value in A In D and E columns i need the Time stamp (D - should contain initial time stamp, E should contain the time stamp in case if the values in B or C changes) I am able to solve the above usecase 90%, i mean i am able to get the time stamp if i enter the values through key board only the time stamp in D and E columns its being updated. If the values updated dynamically in B and C columns then based on that the time stamp is not updating in D and E. Finally i want to know why the dynamic is not being identified by google sheet cells to get the stamp Please let me know if you have any resolution for this problem. Thanks in advance for yur help

[@hudaalraee8794]

I learned a lot from you thanks but can u explain why you used indirect and what it is ? I found your channel before one hour and I learned a lot

[@SahaComputer]

Because you cannot create dynamic reference with offset function in google sheet.

[@sohrabali6080]

Dynamic thanks.

[@SahaComputer]

Thanks for your reply.