Google Sheets ARRAYFORMULA, Introductions to Arrays, ARRAY_CONSTRAIN, SORT Functions Tutorial

Learn how to use ARRAYFORMULA function in Google Sheets as well as arrays in Google Sheets. This tutorial will cover array syntax, ARRAYFORMULA, SORT & ARRAY_CONSTRAIN functions and other tips and tricks.

[ammonjon]

Just this one video completely overhauled my ability to work in Sheets - I really can't overstate how useful this was! I technically understood these concepts, and understood the docs, but actually seeing you working with these cells and ranges made everything so tangible for me. It all just clicked after this video. Thank you for the great content!

[ralphschraven]

Very well-structured. Very "watchable" through the examples. Not too slow-paced, not too fast-paced. Because it's so nicely constructed, it's also easy to traverse through parts that are already known or clear, which makes for a smooth experience watching the video, instead of an "Oh now I missed this", "Oh more irrelevant examples of the same thing", and so on. Noice!

[valleyagcanvasclore]

This is the first time I've experienced a video I wanted to like multiple times and subscribe multiple times. Love your teaching methods! Thank you very much.

[PietroGatto]

The best videos I found on google sheets

[ariarc]

You, sir, write code like a madman, but make it easy to understand. Respect. Thank you for sharing your knowledge and experience.

[walterpaiva]

This is the best channel on google sheets for sure

[callmedanaful]

Holy cow this was so helpful!! thank you! I was able to use Arrayformula to create new columns in my sheet which declares month and quarter without having to populate all rows with the original formula!

[gautamr]

Salutations to probably the best teacher in the world! And trust me this is not exaggeration!

[diegomouratorres]

That's incredible! I'm also learning Microsoft Power BI, and the calculations we can do with array formulas are a lot similar to the calculations we do with calculated columns in Power BI. Finding out that I can do the same in Google Sheets left me pretty happy. That came totally out of left field. Thank you so much!

[AlexandreCaruso]

the best video I found about arrays! finally I understood! congrats!

[mendibenigni]

This is great. I love how you break it all down into its steps first. Very helpful. Love it

[SAlam-boww]

Straight to the point and useful! Feel happy about thumbing up!

[john]

Amazing channel. Amazing author. Great explanation

[NetSkillNavigator]

Amazing tuts! It's working like magic! Thank you so much.

[OliverPohl]

I want to shout it out loud:
THIS IS ABSOLUTE AWESOME!!!

[Golfina]

Your videos are all great, and this one is even better than most!

[FRIK]

THANK YOU SO MUCH!!!
I've tried to solve it for three days!

[jsnhff]

So so so helpful! Thank you. Great lesson in how to use the power of formulas in Sheets.

[voiceofmarwadi]

I love❤️ this channel. Thank you so much👍I get to learn a lot.

[aemma_official]

I’m mind blown! I’ve moved around columns for years!