Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Relative column referencing within formulas
Hi.
I am having difficulty whilst creating formulas. My formula is of the form: B1=A1-C1 B2=A2-D2 B3=A3-E3 ....... I wish to fill the formula down a single column (ie, column B). Whilst using the auto-fill option, the formula will not increment the column reference in subsequent rows. For example, the next row 4 in my worksheet will display: B4=A4-C4 when in fact I wish this to be: B4=A4-F4. Can you please assist in helping me to solve this problem. Many thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Lookup Table Dilemma | Excel Worksheet Functions | |||
Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) | |||
How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) |