Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
How do I increment the row and column of a cell in a formula?
2 views
Skip to first unread message
Dan
Nov 12, 2009, 8:46:03 PM11/12/09
to
I would like to drag a formula down a column, where the cell referred to is
one column right and one row down from the previous cell;
one column right and one row down from the previous cell;
=A1
=B2
=C3
...
Thanks,
Dan
Jacob Skaria
Nov 12, 2009, 8:49:02 PM11/12/09
to
Try the below
=OFFSET($A$1,ROW(A1)-1,ROW(A1)-1)
If this post helps click Yes
---------------
Jacob Skaria
T. Valko
Nov 12, 2009, 10:27:32 PM11/12/09
to
Try this...
Assume you want:
H1 = A1
H2 = B2
H3 = C3
H4 = D4
H5 = E5
Enter this formula in H1 and copy down to H5:
=INDEX(A$1:E$5,ROWS(H$1:H1),ROWS(H$1:H1))
--
Biff
Microsoft Excel MVP
"Dan" <D...@discussions.microsoft.com> wrote in message
news:FBF344EE-820D-4778...@microsoft.com...
0 new messages