Google Apps and Microsoft BPOS Consulting from Interlockit.com |
| ArrayFormula, Match and Offset in Google Spreadsheets Posted: 25 Feb 2014 10:10 AM PST This is a repost of our contribution to the Google Gooru website that provides Tips, Tricks, and Tools for Gmail & Google Apps. 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 is it 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. This video also happens to use our recently released Blink Reports Add-on for Xero Accounting!  |
| You are subscribed to email updates from Google Apps and Cloud Consulting from Interlockit.com To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
No comments:
Post a Comment