Loved how you went step by step and then combined it all in one formula. I prefer to use query to combine data, but enjoyed learning about vstack, hstack, and let functions.
@ExcelGoogleSheets
Жыл бұрын
I'm not a big fan of QUERY function, but that's just my experience.
@antyt2714
Жыл бұрын
Excellent video as usual. I would have used query function but I learned about both V and H stack here. LET function is also new to me and I will certainly be inserting that into some of my exisiting formulas that are a bit long in the tooth. Thanks
@aussiebrian5520
5 ай бұрын
No need for that fancy formula in excel, only in google sheets
@chakralamurali
9 ай бұрын
Excellent video sir. You made my day today. Learnt few extraordinary tips especially clubbing of Vstack and Hstack (selecting only few particular columns)- this is an extraordinary tip which helps me a lot.
@sergheyzaporojanu6872
Жыл бұрын
this is very well put together. Thanks for the tutorial! Do you have video about linking data from different files in Excel and GSheets? I am struggling a bit with Excel since they don't have IMPORTRANGE. And I wish to know some ways to feed the live data acros different Excel files stored on OneDrive. And if there is a way to do the same between OneDrive files and Gdrive sheets, that would be so cool!
@przemysawhajduk8728
8 ай бұрын
This is by far the best method, thank you! Have you considered an extra column to have a partial data sheet's name for each row? I wonder how that can potentially look like
@lpanebr
Жыл бұрын
🤯 So many functions I had never heard of. Thank you! Even text join. I've always used the simple join...
@imamfachrudin7846
Жыл бұрын
Another option, we can create the range by combining with INDEX (we can get the last row from this)
@silvestrecamposano6317
Жыл бұрын
Thank you very much for all the formulas... I can use it in my office work...
@tridibbiswas3361
Жыл бұрын
Thank you for the video. Where can I get the exercise files
@tridsonline
Жыл бұрын
👍🏻 Thanks, great teaching technique! I'm looking forward to trying out some interesting new functions.
@ExcelGoogleSheets
Жыл бұрын
👍
@xjarius
Жыл бұрын
This is awesome, thank you so much for your clear teaching!
@ExcelGoogleSheets
Жыл бұрын
👍
@dannylayton317
Жыл бұрын
Another brilliant video - thank you!
@ExcelGoogleSheets
Жыл бұрын
thank you
@lpanebr
Жыл бұрын
Valeu!
@ExcelGoogleSheets
Жыл бұрын
Thank You!
@gzatt
Жыл бұрын
can't u do all that with a simple query?
@gzatt
Жыл бұрын
the verticals at least. And can u create a named function for that big function u made?
@imamfachrudin7846
Жыл бұрын
He gave another perspective brother
@ExcelGoogleSheets
Жыл бұрын
This particular example would be very difficult to recreate with QUERY function. With QUERY function you need to have at least one column where you can guarantee there will be some data, here you don't. QUERY function is also very particular with data types in your columns and it fails producing results when data types are not universally matched. For me personally, unless I have to use GROUP BY or PIVOT statements I pretty much never use QUERY function because I find it prone to failures.
@ExcelGoogleSheets
Жыл бұрын
Of course you can create a named function, but you could say that about any formula with nested functions.
Пікірлер: 24