Best KZitem channel for Google sheets tutorials. Thumbs up
@ariarc
5 жыл бұрын
Thank you very much for your videos. You are the best source of google sheets training and tutorials I've found on the web.
@sergioave1
4 жыл бұрын
Thank you so much, for the tutorial warm regards form Mexico!
@bigian3262
3 жыл бұрын
ur gay shut up
@hoiyinwan8233
5 жыл бұрын
That was amazing tutorial. I use lookup a lot, seeing it done this way is inspirational!!
@netboy1102
5 жыл бұрын
Learnt alot from you, thank so much! I created my own taxi calculation system from learning the stuff from this.channel.
@abhishekdhyani6520
4 жыл бұрын
Hi sir...I love..this Chanel....I learning lot of things...tqq so much....👌👌
@pancux670
2 жыл бұрын
Best videos on Google sheets. Thanks
@ExcelGoogleSheets
2 жыл бұрын
:)
@argonaut119
3 жыл бұрын
Super Job on the worksheets, the technical stuff and the instruction. The only issue that I find could be different is that one or two sample worksheets being made available would really make these videos near-perfect. And this would be a great marketing move on your part that almost surely would generate greater business interest.
@alansavage3549
6 жыл бұрын
Good tip to combine named ranges. Thanks
@hoiyinwan8233
2 жыл бұрын
Thank you for the great video, it is so good that you have so many useful videos for us to refer back to!!
@ExcelGoogleSheets
2 жыл бұрын
:)
@abirsharda4451
5 жыл бұрын
Really nice video. Helped a lot!
@Bahram_h
4 жыл бұрын
Amazing! Thank you so much. 🙏
@aleahar8668
Жыл бұрын
Explaining could use some work but good work, very informative...
@lazalazarevic6192
6 жыл бұрын
Thank you for another great video!
@mohammadabujafor3568
4 жыл бұрын
Great Initiative, thanks a lot.
@willlewis6622
4 жыл бұрын
Where can I find the sheet you used in this video? Performing the actions helps me to follow along.
@mauspinelli
3 жыл бұрын
SUMIFS saved me, thanks :)
@hoiyinwan8233
6 жыл бұрын
That was amazing video, thank you.
@androidtech1402
2 жыл бұрын
You are awesome! Anyway, It would be much appreciated if you could drop the link for downloading workbooks to practice. Thanks.
@md.abdulmalek7047
6 жыл бұрын
very very effective. thanks
@Anzeljaeg
2 жыл бұрын
ty so much man
@pchelpman
6 жыл бұрын
I'm learning a lot from these, well done and thank you.
@Acuce7ibd468j
4 жыл бұрын
thanks , it is useful
@grAnd4
5 жыл бұрын
*Thank you very much for such useful lessons! Best on KZitem on this subject!* Have a question about this topic: =IMPORTRANGE(someTable; someTab&"!E"&T3) - where T changes T1,T2,T3,... (numbers or IDs) instead of this I want to write =IMPORTRANGE(someTable; "someRange!"&T3) - (what is semantically wrong) where someRange is E:E but how to make it workable?
@ExcelGoogleSheets
5 жыл бұрын
No way to answer without looking at your setup. Share a sample sheet.
@AlexS-jz6pq
3 ай бұрын
Hi, When you use "named ranges" is it needed to put $ to make the reference absolute ? Excel does it automatically when you create named ranges. For instance, when you use the named range for Vlookup without $-sign, does it work correctly when copying formula down?
@MrCarrcon
3 жыл бұрын
Great Videos! Helping out a lot. How would I use named fields if I want to make it a dependent field from a numbered indirect? The numbers from the indirect are weights of a product, and the field I'm trying to add is the quantity.. both drop downs. Can't use #'s in the named range so now I'm stuck lol . Hope you can help. Keep up the great vids!
@มารีโมริ
2 жыл бұрын
Hello! Thank you for teaching this. May I ask if this can be used in Query instead of "selecting" each column?
@murilloolimpio
5 жыл бұрын
Thats cool. Wondering if it's possible when working with 100 tabs where their names are numbers increased by 1 to not have to type all of the different ranges on the query by having a formula that increases the name tabs by 1 collecting their data.
@giovannicaron1187
6 жыл бұрын
Thanks!
@rizwanullah8721
3 жыл бұрын
Thanak a lot for that Just want to ask I’m using range name in my following farmula index(importrange)match(importrange). How can I make ranges dynamic for this task plz
@dreczelhedwigfolloso9339
2 жыл бұрын
It's me again! I'm binged watching every lessons and they are all useful! Thank you! I have one question, is ={ } just the same as =ARRAYFORMULA? From the other episode I've watched, =ARRAYFORMULA also copies or import data from other tabs or sheets and in this video, you used ={ } which seems to have the same function, is it?
@ExcelGoogleSheets
2 жыл бұрын
{} creates an actual single array. ARRAYFORMULA tells the spreadsheets that the formula should be interpreted as a a formula that has embedded arrays. This will make sense over time.
@dreczelhedwigfolloso9339
2 жыл бұрын
@@ExcelGoogleSheets ohh I see, thank you! ☺
@leilahussain9586
3 жыл бұрын
It would be great to have a sheet file like in previous videos
@mdlike5992
4 жыл бұрын
u awesome bro
@paulloup5210
6 жыл бұрын
Thank you
@TheXYZOpera1
4 жыл бұрын
I have a tab template for my Sales with a Named Range and when I copy this, automatically a new Named Range is created. This is perfect. Every new Range starts with Sales and then a year is added. Is there a way to query from all named ranges at once without naming them separately? So something like =Query({Sales*}, "select *", 0) instead of =Query({Sales2015; Sales2016; Sales2017;etc}, "select *", 0).
@idea7960
4 жыл бұрын
Thank you sir
@rambojacksonjr7887
4 жыл бұрын
Is there a video that explains how to link an entire sheet to a certain cell? Almost like an web link ? Or can you only move data
@DonaldAnderson
6 жыл бұрын
Great video. I've been using named ranges to great effect. However, I have a spreadsheet where new data gets entered every morning. On my master tab I'd like to display whatever the latest input was. I, so far, have been unable to figure this out. Help!
@ExcelGoogleSheets
6 жыл бұрын
I think you should be able to apply named range for the whole column. So select columns and then try to define named range.
@aleborissa
4 жыл бұрын
I have some sheets with lots of cells using importrange function. My problem is that each sheet have different information and if my first sheet which has names changes, the names on the other sheets will change and I will lose the information corresponding to each name on the following sheets. For example: my first sheet has a column with the names and some personal information for BOB, ADAM, DAVID, CLARK. Now my second sheet brought those names in in that same order and the second sheet will then have grades for each one of them: BOB 10, ADAM 9, DAVID, 5 and CLARK 8. Now, lets say, I decide to put the first sheet in alphabetical order: ADAM, BOB, CLARK, DAVID. And that's where my problem is, because now in the second sheet ADAM has 10 points, BOB has 9, CLARK has 5 and DAVID has 8. How can I make the following cells change automatically with the first cell when using importrange?
@AnyPossibleRandomThing
2 жыл бұрын
Will naming a range still works if you remove the end refernece? So if the data for that range updates it woul be included under the Name range you setup? Or that's not possible?
@ExcelGoogleSheets
2 жыл бұрын
Doesn't work, at least for now.
@Andy6572
6 жыл бұрын
Is there a way to add multiple defined ranges when using the query?
@afifahkhairunnisa6379
3 жыл бұрын
Hi, I wonder if I could get the sheet file. Thank you
@hanshima_
4 жыл бұрын
Can I use the named range to create pivot table? I'm having troubles to use my named range to create pivot tables, but that works well with formulas.
@ExcelGoogleSheets
4 жыл бұрын
No.
@hanshima_
4 жыл бұрын
@@ExcelGoogleSheets Thanks anyway, your channel is the best one about the topic.
@moritzw42
5 жыл бұрын
Thanks man! Why did you use curly braces @ 7:40? Was that some other programming language you can use in sheets? I only knew of SQL and VBA till now.
@ExcelGoogleSheets
5 жыл бұрын
Array syntax. Watch my introduction to arrays video for more information.
@malharshembekar1026
4 жыл бұрын
I have a table where new entries come as new columns. How do I have it become a dynamic named range?
@lotusvines3698
4 жыл бұрын
how to import a range along with formula in google sheets
@ursraj27
5 жыл бұрын
Can I use Named Ranges as source data for pivot table?
@ExcelGoogleSheets
5 жыл бұрын
Not at the moment.
@CalebHopkins
4 жыл бұрын
So I've got 2 named ranges now, one is "Sheet1!A1:A32" named as AllCommon, the other is "Sheet1!B1:I8" named as OtherCommon. When I do "={AllCommon;OtherCommon}" I get a Formula parse error. when i do "={AllCommon:OtherCommon}" it shows them correctly, but I also get cells B9:I32 included too. Do you know how to get rid of them? As I don't really want them in the range. I'll create a new document and add an example (Link Below). I've got most of it working, I'm trying to pick a random name from a list, but things mess up once I'm trying to pull 1 from multiple lists. (Sheet 2 is where the broken formulas are, Sheet 1 is just the list) docs.google.com/spreadsheets/d/1QNWVofSwuUe8S-raA9lHreWG2mB9TpPf-dkP-ox59qk/edit?usp=sharing
@ExcelGoogleSheets
4 жыл бұрын
use 2 separate formulas. ={AllCommon} and then int he next column do ={OtherCommon}
@CalebHopkins
4 жыл бұрын
@@ExcelGoogleSheets Ooo okay :o Thank you :) I've found a couple of work arounds now too, I made each of B1:8, C1:8, ect to I1:8 as separate named ranges, and that seemed to work, a little messy but functional. But I'll defiantly give that one ago too :) Thank you. I like learning the different ways to do stuff. You never know when it'll come in handy hehe.
@NirmalyaSaha13
6 жыл бұрын
Can we use referencing in importrange function?
@ExcelGoogleSheets
6 жыл бұрын
yes.
@NirmalyaSaha13
6 жыл бұрын
@@ExcelGoogleSheets. Thanks for the reply.. I couldn't able to do that.. I tried absolute referencing, but it didn't apply. Kindly help me out.
@ExcelGoogleSheets
6 жыл бұрын
I misunderstood your question, I thought you were asking if you can reference a named range in importrange. Reference in importrange function is text, therefore it will act as an absolute reference all the time. You could do some trickery and concatenate text with row() function to make it work like a relative reference if needed, but otherwise no.
@naveenofficial3680
5 жыл бұрын
Why formulas not refreshing automatically?? Even i'm not able to find any option to refresh manually
@ExcelGoogleSheets
5 жыл бұрын
check your settings under File->Spreadsheet Settings
@naveenofficial3680
5 жыл бұрын
@@ExcelGoogleSheets thank u sir
@RaymundoCastillo007
6 жыл бұрын
Thanks in advance for your help. I have 2 sheets: 1.-Master: Here I import a csv file and made calculation. 2.-Report: Here only use the importrange function. The imported data for the importrange function give me almost columns correct but some columns with: #value! or #N/A I checked my formula and I thinks is correct, I search in the Help Forum and I tried with some changes in format, formula, permission. But I can´t make it work. =iferror( importrange("1pp9f8uPyEOyitZY7UuB4sqQu-7ScukCttVqmxun0hz8/edit#gid=103974437", upper("Filtro_dia!A1:i300")), importrange("1pp9f8uPyEOyitZY7UuB4sqQu-7ScukCttVqmxun0hz8/edit#gid=103974437", lower("Filtro_dia!A1:i300"))) ¿can you help me?
@ExcelGoogleSheets
6 жыл бұрын
What are you trying to do? Your formula just for importrange should be =importrange("1pp9f8uPyEOyitZY7UuB4sqQu-7ScukCttVqmxun0hz8", "Filtro_dia!A1:i300")
@dipaksingh1751
4 жыл бұрын
Sir Importange duplicate data problem...
@zalbortroxzalbortox1565
6 жыл бұрын
Is there a way to add up numbers in a formula when in between other words such as if they were part of email addresses such as user1@gmail.com, user2@gmail.com, user3@gmail.com ect
@wirot125
5 жыл бұрын
I created web app but blocked. How should I do?
@SoneSimzc
4 жыл бұрын
={Year2017,Year2018,Year2019} seem not working, it just show the first array on the first tab :(
@ExcelGoogleSheets
4 жыл бұрын
={Year2017;Year2018;Year2019}
@SoneSimzc
4 жыл бұрын
@@ExcelGoogleSheets Not working :(
@drsiiiiin
4 жыл бұрын
To make it easy It would have been better if you quick explain whats the function do then start the video
@nehasharma-mi9og
6 жыл бұрын
HOW TO DISPLAY IMAGE DYNAMICALLY IN GOOGLE SHEET
@eduardtruhling9213
4 жыл бұрын
Hi, Thanks for the tutorial. I am trying to plot data in a graph where the range of data is dependent on selection. I've managed to do the application in MS Excel (with assistance from the following video: kzitem.info/news/bejne/1H6cvYaYa6uGpYI) I would like to do a similar application in sheets? Please give me some guidance. Your assistance will be useful. Thanks. Regards, Ed
Пікірлер: 80