| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Newbie: Help with OFFSET function
On Sheet1 I and Row106 I have 50+ columns of calculation results that I want
copied to Sheet2, Column 4 over the equivalent number of rows. =OFFSET('Recipe Calculation'!$D$106,COLUMN()-4,0) ....the result of Sheet1, Row106 and Column4 is dead on, but when I want to copy the above function to the other cells of Column4 on Sheet2, the result is always the same as on the first cell. What am I doing wrong? I can't get my head around this and the Excel Help file is not much better than the Excel book I have. Please help. Thanks in advance...Carlos |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Offset function referencing worksheet | Excel Discussion (Misc queries) | |||
| offset function | About this forum | |||
| Troubles with the OFFSET function | Excel Worksheet Functions | |||
| IF function to blank without getting #value in sum function | Excel Worksheet Functions | |||
| Function Won't Calculate -- Sometimes | Excel Discussion (Misc queries) | |||
Threaded Mode
