D
Danni2004
Hi
Below is a simple example of my data. The bottom shows a table that pulls
averages from another table above. Could someone help me create an OFFSET
formula that will pull six rows down from the prior period's average?
You can see that Per 01 averages for Load 1, 2 & 3 just equal row 5 of the
table. If I just do an OFFSET for six rows down from D18, it pulls from cell
D25. If I refer to the cell in the primary table where Per 01's average is
(D5), I won't be able to just copy the formula down through subsequent
periods.
Hope this question was clear.
A B C D
1 Period 01
2 Load 1 Load 2 Load 3
3 Reg 1 231 225 234
4 Reg 2 245 236 244
5 Average 238 231 239
6
7 Period 02
8 Load 1 Load 2 Load 3
9 Reg 1 228 230 239
10 Reg 2 243 227 233
11 Average 236 229 236
12
13 Period 03
14 Load 1 Load 2 Load 3
15 Reg 1 246 241 232
16 Reg 2 242 226 240
17 Average 244 234 236
18
19 Averages
20 Load 1 Load 2 Load 3
21 Period 01 238 231 =E5
22 Period 02
23 Period 03
Below is a simple example of my data. The bottom shows a table that pulls
averages from another table above. Could someone help me create an OFFSET
formula that will pull six rows down from the prior period's average?
You can see that Per 01 averages for Load 1, 2 & 3 just equal row 5 of the
table. If I just do an OFFSET for six rows down from D18, it pulls from cell
D25. If I refer to the cell in the primary table where Per 01's average is
(D5), I won't be able to just copy the formula down through subsequent
periods.
Hope this question was clear.
A B C D
1 Period 01
2 Load 1 Load 2 Load 3
3 Reg 1 231 225 234
4 Reg 2 245 236 244
5 Average 238 231 239
6
7 Period 02
8 Load 1 Load 2 Load 3
9 Reg 1 228 230 239
10 Reg 2 243 227 233
11 Average 236 229 236
12
13 Period 03
14 Load 1 Load 2 Load 3
15 Reg 1 246 241 232
16 Reg 2 242 226 240
17 Average 244 234 236
18
19 Averages
20 Load 1 Load 2 Load 3
21 Period 01 238 231 =E5
22 Period 02
23 Period 03