ArrayFormula - Google Sheets
Today, I share with you one of my favourite formulas in Google Sheets, the ARRAYFORMULA function.
Enjoy it and thank you for watching!
If you want to learn more about FILTER and FLATTEN functions, you can watch my previous videos:
Filter - Excel and Google Sheets - • Video
Split and Flatten Functions - Google Sheets - • Split and Flatten Functions - Google ...
0:00 Intro
0:19 Overview
1:00 The ARRAYFORMULA function
2:55 Combining ARRAYFORMULA and FILTER
5:20 How Excel Presents Dynamic Arrays
6:12 Tip on how to identify the cell with the ARRAYFORMULA function
7:10 Something to watch out for, when selecting full columns
8:56 Combining ARRAYFORMULA and FLATTEN
11:40 Combining ARRAYFORMULA, FLATTEN and TRANSPOSE
12:10 Wrap Up
#GoogleSheets