Copping Formula

Occasional Visitor

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?

4 Replies

@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.

 

 

@Aj_2653 

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

@Sergei Baklan 

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?

@Peter Bartholomew , that's forever. The only LAMBDA option will be suggested more often among others.