Enables the display of values returned from an array formula into multiple rows and/or columns and the use of non-array functions with arrays.

How To Use in Sheets


External Links

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

earn 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.

12Better Sheets Tutorials

Build a habit tracker in dark mode. Learn how to use emojis and checkboxes effectively.
Build a list of domains you can buy right now. Easily check if the domain you want is still available.
Go from nothing to a working PR agency. Capture sites, and Send email via script
Got a list of names, need to add new ones to main list.
Search and find duplicates that are spelled differently.
Created a daily email with a motivational quote in the subject.


Quick intro to a better experience of using Google Sheets