Array Formula, Match and Offset in Google Spreadsheets
The arrayformula in Google Spreadsheets has a number of great different use cases. This video pairs the arrayformula with Match and Offset to pull in a constantly updating range of data in one sheet to create a chart in another sheet.
The advantage of using the arrayformula in conjunction with Match and Offset allows you to constantly add rows to your selected range, so you never have to worry about updating the formula. This would work great, for example, if you were pulling from the responses from a Google Form and wanted to consolidate them into a chart.
To watch the updated video and read the full article on the BetterCloud Monitor, visit: https://www.bettercloud.com/monitor/the-academy/array-formula-match-and-offset-in-google-spreadsheets/
Digital Offset Printing