| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
incrementing formula reference by 7
I've tried several different ways to do this with no luck. I have a formula
in a cell that refers to a cell on another worksheet in the same book. I need to have each subsequent formula (horizontally) refer to the cell referenced, but offset by 7 rows. Here's the example: Cell A1 formula Cell A2 should refer to Cell A3 should refer to ='Raw Data'!$E1 ='Raw Data'!$E8 ='Raw Data'!$E15 Help please? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cell reference in a formula is called | Excel Discussion (Misc queries) | |||
| Copying a mixed reference formula | Excel Discussion (Misc queries) | |||
| copying a formula, the reference adjusts, but the result does not | Excel Discussion (Misc queries) | |||
| Formula with text and reference to a date cell | Excel Discussion (Misc queries) | |||
| Using a formula in a Hyperlink Cell reference | Excel Discussion (Misc queries) | |||
Threaded Mode
