Pages

Tuesday, 12 November 2019

How to use 'offset' in a Google Sheet

The following Google Apps Script is a simple example of using 'offset' to return a new range from one previously given. So if we take cell A1 for instance and offset by 1 row & 1 column we would end up with cell B2. If we take cell A1 and offset by 2 rows & 3 columns we would end up with D3.
Screenshot of Google Sheet with values from offset function
Screenshot of Google Sheet with values from offset function

offset apps script example

No comments:

Post a comment