Pardon me. Doesn't work.
Hans

"Hans Knudsen" <a@b.com> skrev i en meddelelse news:u5Tcr2VZGHA.1348@TK2MSFTNGP05.phx.gbl...
> The following worked for me.
> In B5: ="=A"&30-ROW(A1)&"-"&"A"&ROW(A5)
> Copy down to B30. Now take a copy of B5:B30 and paste as values to (for example) C5:C30. Highligt C5:C30, press F2, hold down Ctrl
> while pressing Enter. Now you should have the formulas in C5:C30. Cut and paste back to B5:B30 if you want.
>
> Hans
>
>
> "mworth01" <mworth01.26mf8q_1145634023.1264@excelforum-nospam.com> skrev i en meddelelse
> news:mworth01.26mf8q_1145634023.1264@excelforum-nospam.com...
>>
>> 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
>>
>
>