ARRAYFORMULA()

Description

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

ARRAYFORMULA(array_formula)

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.

Google Docs Help

12Better Sheets Tutorials

Benoit Asks: How to Convert Case

FREE

How to Make a Marketplace in a Google Sheet

Intermediate

Creating A Dark Mode Theme | Announcing Dark Habits

Intermediate Most Popular

Build a habit tracker in dark mode. Learn how to use emojis and checkboxes effectively.

Find Hundreds of Available Domains From Keywords with Concat and Array Formula

Intermediate Most Popular

Build a list of domains you can buy right now. Easily check if the domain you want is still available.

FREE

Secure Your Sheets by BetterSheets.co

Beginner

Deep Inside Dark Habits Google Script

How to Iterate Counting Blank Cells in Google Sheets

Intermediate

Create a PR Agency From Scratch

Go from nothing to a working PR agency. Capture sites, and Send email via script

Wallace Asks: How To Find New Names

Got a list of names, need to add new ones to main list.

Discover Duplicates Misspelt

Beginner

Search and find duplicates that are spelled differently.

Send a Daily Email with Inspiring Quote - A Little Pick Me Up

Intermediate

Created a daily email with a motivational quote in the subject.

FREE

Learn to Love Your Sheets

Beginner

Quick intro to a better experience of using Google Sheets