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 |
offset apps script example (please use 'Overview' > 'Make a copy' for your own version).
No comments:
Post a Comment