Excel Increment columns in rows

[Guest]

How do I increment columns into rows in a formula. A1 = b4 + 2, A2 = C4 + 2,
A3 = D4 + 2 etc.
Excel XP

 

[Jason Morin]

Try this in A1:

=OFFSET($B$4,,ROW()-1)+2

HTH
Jason
Atlanta, GA

 

[Aladin Akyurek]

In A1 enter & copy down:

=INDEX($B$4:$N$4,1,ROW()-ROW($A$1)+1)+2

Adjust the range B4:N4 to suit.

 

[Max]

One way:

Put in A1:

=OFFSET($B$4,,ROWS($A$1:A1)-1)+2

Copy down

 

[Guest]

Thanks to all of you.. Wow how fast...