How do I increment the row and column of a cell in a formula?
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" wrote in message
...
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
|