How do I increment the row and column of a cell in a formula?

[Dan]

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;

=A1
=B2
=C3
....

Thanks,
Dan

 

[Jacob Skaria]

Try the below

=OFFSET($A$1,ROW(A1)-1,ROW(A1)-1)

If this post helps click Yes

 

[T. Valko]

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))