JenniferMurphy
Well-known Member
- Joined
- Jul 23, 2011
- Messages
- 2,532
- Office Version
- 365
- Platform
- Windows
In the following table, I need the formulas in columns H & I to refer to the data in column G but at one row down. Column E is assigned the name PP_A, column F the name PP_B, and column G the name Iterations.
I would like to replace the references to column G in the formulas with the name of that column, but if I do, I get the cell in G on the same row as the calling cell.
<tbody>
</tbody>
I have tried using Cell, Address, Offset, Row, Column and other functions, but have not been able to get anything to work.
Does anyone have any magic I can use?
Thanks
I would like to replace the references to column G in the formulas with the name of that column, but if I do, I get the cell in G on the same row as the calling cell.
R/C | C | D | E | F | G | H | I | J | K |
5 | PGS_A | PGS_B | PP_A | PP_B | Iterations | Wins_A | Wins_B | Formulas | Formulas |
6 | 52.00% | 50.00% | 51.35% | 48.65% | 61,620 | 58,380 | H6: =G7*PP_A | I6: =G7*PP_B | |
7 | 120,000 | ||||||||
8 | 62.00% | 60.00% | 51.59% | 48.41% | 185,724 | 174,276 | H8: =G9*PP_A | I8: =G9*PP_B | |
9 | 360,000 | ||||||||
10 | 72.00% | 70.00% | 52.02% | 47.98% | 249,696 | 230,304 | H10: =G11*PP_A | I10: =G11*PP_B | |
11 | 480,000 |
<tbody>
</tbody>
I have tried using Cell, Address, Offset, Row, Column and other functions, but have not been able to get anything to work.
Does anyone have any magic I can use?
Thanks