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.

🤯 So many functions I had never heard of. Thank you! Even text join. I've always used the simple join...

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

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.

Thank you very much for all the formulas... I can use it in my office work...

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

👍🏻 Thanks, great teaching technique! I'm looking forward to trying out some interesting new functions.

@ExcelGoogleSheets

Жыл бұрын

👍

This is awesome, thank you so much for your clear teaching!

@ExcelGoogleSheets

Жыл бұрын

👍

Another brilliant video - thank you!

@ExcelGoogleSheets

Жыл бұрын

thank you

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!

Valeu!

@ExcelGoogleSheets

Жыл бұрын

Thank You!

Thank you for the video. Where can I get the exercise files

Another option, we can create the range by combining with INDEX (we can get the last row from this)

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.

No need for that fancy formula in excel, only in google sheets