Automatic Formula By Rows

(Ever want to create formulas that can automatically fill down below instead of having to copy / pasting or pulling down the formula? This video shows how you can do this with the BYROW() and LAMBDA() Functions!
Check out my Blog if you want to read instead of watch:
wordpress.com/...
Here's the example sheet:
docs.google.co...
⏳Timestamps:
(00:00) Introduction
(00:25) Using PROPER() the Regular Way
(01:25) Using ARRAYFORMULA() With PROPER()
(01:54) Using LAMBDA()
(03:22) Using BYROW() with LAMBDA()
(05:34) Using BYROW()/LAMBDA() with a Lookup Function
(09:32) Limitation with BYROW()
(11:42) LAMBDA Has Another way to MAP Multiple Columns
(12:32) Conclusion
(13:03) End Slides
🗣️Socials:
WEBSITE: matttechtidbit...
REDDIT: / matttechtidbits
INSTAGRAM: / matttechtidbits
Need a Freelancer? Check out my Upwork Profile:
www.upwork.com...
🎵Music is "WFH" made by me with my solo music project name, Ambiosynthesis
• WFH
-
#️⃣
#sheets
#spreadsheet
#googlesheets
#technology