Copping Formula

%3CLINGO-SUB%20id%3D%22lingo-sub-2239229%22%20slang%3D%22en-US%22%3ECopping%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2239229%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20have%20a%20formula%20with%20reference%20say%20A1.%20I%20want%20to%20copy%20this%20formula%20to%20next%20right%20cell%20with%20reference%20D1%20and%20to%20next%20G1%20and%20so%20on%2C%20How%20can%20I%20do%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2239229%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
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.