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
This workshop is not currently scheduled. Please contact us to schedule a session for you.
Resources
Preview the Slides
Watch an Overview of this Topic
Learn More About This Service
Google Drive
Google Drive provides a single place to store, access, create, edit, sync, and share documents, files, and folders of all types. You can easily access files anywhere - at your desk, from home, or on a mobile device.
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
- doit_training@stonybrook.edu
- (631) 632-9800
- Website