Google Sheets: OFFSET with array parameters
I'm not very familiar with Google Sheets, and so hope that someone can point me in the right direction here.
I am quite surprised that some of the standard constructions which use OFFSET with one or more parameters comprising an array of values do not seem to work in Sheets.
For example, with A1, A2 and A3 containing 1, 2 and 3 respectively, both:
return 6 in Excel, since they both resolve to:
In Google Sheets, however, both return 1, evidently since they are only processing the first cell in the range, i.e. A1.
I have tried committing the above as array formulas in Sheets, but this does not change anything.
Is it not possible to pass an array of values to OFFSET in Google Sheets? If so, this would seem to be a serious failing: part of OFFSET's versatility is its ability to accept arrays for one or two parameters, allowing us to construct multi-dimensional arrays of range offsets.
Hoping somebody more familiar with Sheets can clarify.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By dmcmaste in forum Excel Formulas & Functions
Last Post: 03-31-2020, 01:35 PM
By dathgr in forum Excel General
Last Post: 12-19-2018, 06:30 AM
By excelroofing in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
Last Post: 08-22-2018, 02:06 AM
By sharadmaxwell in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
Last Post: 07-25-2018, 08:40 AM
By nappy1001 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
Last Post: 04-20-2018, 12:14 PM
By ckserra in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
Last Post: 01-04-2018, 01:59 PM
By redline24 in forum Excel Formulas & Functions
Last Post: 02-10-2015, 04:00 PM
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1