Array Formulas in Google Sheets (or 1 Formula To Populate a Whole Column of Data)

If you have 100s or 1000s of rows of data that you need to perform calculations on, for example, use 1 array formula to populate all the values.

Audience: Clubs, Faculty, Guests, Postdocs, Researchers, Staff, Students and Teaching Assistants

Workshop Level: Intermediate

At the End of This Workshop You Will Be Able To

Use Array Formulas in Google Sheets

Array Formulas allow you to write one formula to populate values down an entire column, for example (no need to copy the formula down the column). Use it to sum or average columns, search for matches, and more. 


Preview the Slides

Watch an Overview of this Topic

Additional Information

View Related Workshops In

Hosted By

DoIT Training and Development