F
FGM
How do I increment columns into rows in a formula. A1 = b4 + 2, A2 = C4 + 2,
A3 = D4 + 2 etc.
Excel XP
A3 = D4 + 2 etc.
Excel XP
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jason Morin
Try this in A1:
=OFFSET($B$4,,ROW()-1)+2
HTH
Jason
Atlanta, GA
=OFFSET($B$4,,ROW()-1)+2
HTH
Jason
Atlanta, GA
A
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.
=INDEX($B$4:$N$4,1,ROW()-ROW($A$1)+1)+2
Adjust the range B4:N4 to suit.
M
Max
One way:
Put in A1:
=OFFSET($B$4,,ROWS($A$1:A1)-1)+2
Copy down
Put in A1:
=OFFSET($B$4,,ROWS($A$1:A1)-1)+2
Copy down
G
Guest
Thanks to all of you.. Wow how fast...