First enter:

=INDIRECT(ADDRESS(34-ROW(),1))-A4
in B4 and copy down

Then read Excel Help on both ADDRESS() and INDIRECT(). They are both really
neat!
--
Gary's Student


"mworth01" wrote:


I have one column with numbers ranging in cells from A4 to A30. I want
to create a formula in B4 and then copy the formula down so that the
formula adjusts automatically so that the following results:

Cell Formula
B4 =A30-A4
B5 =A29-A5
B6 =A28-A6
B7 =A27-A7
etc.

My problem is if I create a formula and copy down, the A4 to A5 part
works but A30 wants to become A31 instead of A29. I then tried a
series of equations using INDEX and ROW, but can't seem to find the
right combonations that Excel will allow. This seems like it should be
relatively simple but I'm stumped. Any advice? Thanks in advance.


--
mworth01
------------------------------------------------------------------------
mworth01's Profile: http://www.excelforum.com/member.php...fo&userid=8991
View this thread: http://www.excelforum.com/showthread...hreadid=535004