Mar 27 2021 01:59 AM
Hi,
I have a formula with reference say A1. I want to copy this formula to next right cell with reference D1 and to next G1 and so on, How can I do this?
Mar 27 2021 02:28 AM
@Aj_2653 That could be something like:
=OFFSET($A$1,0,(COLUMN()-1)*3)
assuming the first formula is in column A of a sheet. If that's not the case you need to adjust the -1 with the column number where the first formula is entered.
Mar 27 2021 02:43 AM
It depends on which formula and where it is located. Assuming in H3 you have =A1+1, you may change it on
=INDEX(1:1, 1, 3*(COLUMN()-COLUMN($H$1))+1,1)+1
and drag to the right
Mar 27 2021 04:03 AM
I wonder how long it will be before the answer is
= LAMBDA(k,
INDEX(source,3*(k-1)+1)
)({1,2})
Maybe forever, perhaps 'drag' to the right will always be a requirement?
Mar 27 2021 05:16 AM
@Peter Bartholomew , that's forever. The only LAMBDA option will be suggested more often among others.