Google Sheets tutorial: Using function ARRAYFORMULA ARRAYFORMULA is a function that outputs a range of cells instead of just a single value and can be used with non-array functions. Read More →