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. 

Current Workshop Schedule

Resources

Preview the Slides

Additional Information


View Related Workshops In

Hosted By

If you have any questions regarding this workshop or would like to see this workshop offered please contact


DoIT Training and Development