#139

  Рет қаралды 7,490

Saha Computer Education Centre

Saha Computer Education Centre

Күн бұрын

Пікірлер: 27
@debdeepbhowmick7107
@debdeepbhowmick7107 2 жыл бұрын
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
@shantisawaroopsharma877 2 жыл бұрын
I learnt a lot from your videos. You understand the functions very deeply
@SahaComputer
@SahaComputer 2 жыл бұрын
Glad to hear that!
@Schlaggonwaggon
@Schlaggonwaggon 2 жыл бұрын
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
@jwalk777778 2 жыл бұрын
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
@SahaComputer 2 жыл бұрын
=SUMIFS(C2:C7,B2:B7,">="&A2,B2:B7,"
@jwalk777778
@jwalk777778 2 жыл бұрын
Awesome! Thank you so much!
@SahaComputer
@SahaComputer 2 жыл бұрын
You're welcome
@composure7394
@composure7394 2 жыл бұрын
Thanks a million
@SahaComputer
@SahaComputer 2 жыл бұрын
Thanks for the comment.
@10shyam
@10shyam 3 жыл бұрын
Thank you very much sir. You the best I got here what I was searching for.
@SahaComputer
@SahaComputer 3 жыл бұрын
Glad to hear that
@tigerlilly6895
@tigerlilly6895 2 жыл бұрын
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
@SahaComputer 2 жыл бұрын
Thanks for your comment.
@krishnatate4765
@krishnatate4765 5 ай бұрын
Thank u sir
@SahaComputer
@SahaComputer 5 ай бұрын
Welcome
@mrigendraverma9631
@mrigendraverma9631 3 жыл бұрын
Very well explained indeed
@SahaComputer
@SahaComputer 3 жыл бұрын
Thanks for your comment.
@firmanyuliansyahkurachman1987
@firmanyuliansyahkurachman1987 2 жыл бұрын
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
@firmanyuliansyahkurachman1987 2 жыл бұрын
especially for candlestick charts
@SahaComputer
@SahaComputer 2 жыл бұрын
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
@usmanahmad7758 6 ай бұрын
Great 🎉 I've question, can indirect function be added in name range?
@ubnuday
@ubnuday 3 жыл бұрын
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
@hudaalraee8794 3 жыл бұрын
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
@SahaComputer 3 жыл бұрын
Because you cannot create dynamic reference with offset function in google sheet.
@sohrabali6080
@sohrabali6080 3 жыл бұрын
Dynamic thanks.
@SahaComputer
@SahaComputer 3 жыл бұрын
Thanks for your reply.
#141-Google Sheets Tutorials: How to Highlight Alternate Rows in Google Sheets
6:26
Saha Computer Education Centre
Рет қаралды 505
Named Ranges - Excel & Google Sheets
12:11
Learn Google Sheets & Excel Spreadsheets
Рет қаралды 4,9 М.
😜 #aminkavitaminka #aminokka #аминкавитаминка
00:14
Аминка Витаминка
Рет қаралды 2,3 МЛН
Всё пошло не по плану 😮
00:36
Miracle
Рет қаралды 5 МЛН
How To Create MULTIPLE Dependent Drop-Down Lists in Google Sheets
8:13
Google Sheets: Dynamic Arrays - SORTN, SPLIT, QUERY, SPARKLINE++
14:40
Google Sheets - Named Ranges, Dynamic Updates, with IMPORTRANGE, Other Sheets, Arrays - Tutorial
20:18
Learn Google Sheets & Excel Spreadsheets
Рет қаралды 106 М.
Better tables in Google Sheets with 20 rarely used tips
16:47
David Benaim
Рет қаралды 16 М.
QUERY - Drop Down List to Filter Data - Google Sheets
15:25
Learn Google Sheets & Excel Spreadsheets
Рет қаралды 352 М.
10 Google Sheets Tips You DON'T Want to Miss
13:51
Leila Gharani
Рет қаралды 574 М.
Excel Tables Tutorial - Dynamic Expandable Range
17:15
Learn Google Sheets & Excel Spreadsheets
Рет қаралды 24 М.
Task Management Tracker in Google Sheets | Step by Step tutorial
16:35
Neotech Navigators
Рет қаралды 16 М.
Google Sheets - Define and Use Named Ranges
8:30
Prolific Oaktree
Рет қаралды 91 М.