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 <at>yahoo<dot>com
----
FGM <[email protected]> wrote in message
news:[email protected]...
> 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
>.
>