Excel Increment columns in rows
 

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

Try this in A1:

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

HTH
Jason
Atlanta, GA

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

In A1 enter & copy down:

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

Adjust the range B4:N4 to suit.

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

One way:

Put in A1:

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

Copy down
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
FGM wrote in message
...
How do I increment columns into rows in a formula. A1 = b4 + 2, A2 = C4 +
2,
A3 = D4 + 2 etc.
Excel XP

Thanks to all of you.. Wow how fast...
-----Original Message-----
How do I increment columns into rows in a formula. A1 =
b4 + 2, A2 = C4 + 2,
A3 = D4 + 2 etc.
Excel XP
.