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
>.
>
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
>.
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks