Home > database >  Google Sheets COLUMN TOP ArrayFormula to calculate ROW wise which require ROW-wise ArrayFormula
Google Sheets COLUMN TOP ArrayFormula to calculate ROW wise which require ROW-wise ArrayFormula

Time:02-17

Ref link below.

Essentially the aim to get a geometric progression with each term repeated X times.

The correct result on the sheet is obtained using an ArrayFormula across a row. This requires copying the formula column wise.

What I would like is a single ArrayFormula atop the column, that calcluates the results row wise (as indicated). My attempt on the sheet fails.

enter image description here

  • Related