How to drag a formula to the right, but skip columns

[Remaniak]

Hi All,

If I drag a formula to the right it adapts the column letter in the formula from A to column B, which is standard Excel functionality.

However, if I drag the formula to the right I want Excel to skip a column each time.

In other words:

=A1 ; = B1 ; = C1

Should be

=A1 ; = C1 ; = E1 etc...

Is there an easy trick to do this?

Thanks,

Michiel

 

[Jonmo1]

You need 2 formulas....


in A2, enter

=A1

in B2 enter

=INDEX(1:1,1,COLUMN()+COLUMN(A1))

Fill right.

 

[Remaniak]

Thanks a lot,

Question though. I used a simplyfied sample. I don't know how to correctly adapt it to the real situation:

I am in sheet "Analysis" cell L5. The formula in this cell is "=Answers!G4"

In cell M5 (analysis sheet) I need to adapt the formula to "=Answers!I4"

How would I implement your solution with this?

Thanks

Michiel

 

[Jonmo1]

=INDIRECT("Answers!"&ADDRESS(4,COLUMN(H1)+COLUMN(A1)))

 

[Remaniak]

Thanks a lot!

Really works out great!