Google Spreadsheets, how do I make an array formula?

**puretppc** · 02-01-2014, 01:48 AM

So lets say I define these:

Please Login or Register  to view this content.

How do I use array formula for Column A so that as I go down, I add 1 towards the previous?

**MarvinP** · 02-01-2014, 02:06 AM

Hi puretppc,

Did you see this is an Excel forum and not a Google Spreadsheet forum??
I think you do a CSE formula where you hold down the ctrl and shift keys while you hit enter, just like it says on the bottom of this link:
https://support.google.com/drive/answer/71291?hl=en

**puretppc** · 02-02-2014, 08:13 PM

Originally Posted by MarvinP

Hi puretppc,

Did you see this is an Excel forum and not a Google Spreadsheet forum??
I think you do a CSE formula where you hold down the ctrl and shift keys while you hit enter, just like it says on the bottom of this link:
https://support.google.com/drive/answer/71291?hl=en

I deliberately posted this on this section which consists of "Google Docs", similar concept to Google Spreadsheets. I don't really know how to use it though when I checked that link.