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.
Resources
Preview the Slides
Watch an Overview of this Topic
Browse DoIT Events
Learn More About This Service
Google Drive
Google Drive provides a single place to store, create, sync, and share documents, files, and folders of all types. Access files anywhere - at your desk, from home, or on a mobile device.
Browse DoIT Events
Additional Information
View Related Workshops In
Hosted By
DoIT Training and Development
- doit_training@stonybrook.edu
- (631) 632-9800
- Website