# Copping Formula

Occasional Visitor

# Copping Formula

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

# Re: Copping Formula

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

# Re: Copping Formula

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

# Re: Copping Formula

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?

# Re: Copping Formula

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