| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying formula with cell reference decreasing automatically
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is it possible? | Excel Worksheet Functions | |||
| Dynamically-linked formula, cell reference in the string | Excel Worksheet Functions | |||
| copied formula has correct cell reference, but result of original | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Copying a mixed reference formula | Excel Discussion (Misc queries) | |||
Threaded Mode
