Diane Parker
New Member
- Joined
- Jul 12, 2012
- Messages
- 3
Need help taking the last data point (DCP) off several dynamic linear charts. The last data point is the weekly average and it often creates a blip at the end of the data. No VBA please. Thank you so much.
=OFFSET(Current!$A$1,25,MATCH(Current!$A$172,Current!$B$1:Current!$XEA$1,0),1,MATCH(Current!$A$174,Current!$B$1:Current!$XEA$1,0)-MATCH(Current!$A$172,Current!$B$1:Current!$XEA$1,0))
<tbody>
</tbody>
=OFFSET(Current!$A$1,25,MATCH(Current!$A$172,Current!$B$1:Current!$XEA$1,0),1,MATCH(Current!$A$174,Current!$B$1:Current!$XEA$1,0)-MATCH(Current!$A$172,Current!$B$1:Current!$XEA$1,0))
A | DCI | DCJ | DCK | DCL | DCM | DCN | DCO | DCP | |
8/21/2019 | 8/22/2019 | 8/23/2019 | 8/24/2019 | 8/25/2019 | 8/26/2019 | 8/27/2019 | Weekly Avg | ||
3 | 3 | 19.0 | 19.1 | 18.8 | 19.5 | 19.5 | 19.6 | 19.5 | 19.3 |
4 | 4 | 19.3 | 19.5 | 19.7 | 19.7 | 19.9 | 20.2 | 20.3 | 19.8 |
5 | 21 | 20.6 | 21.0 | 21.0 | 20.9 | 21.5 | 21.6 | 21.8 | 21.2 |
6 | 22 | 20.3 | 20.1 | 20.3 | 20.4 | 20.5 | 20.5 | 20.8 | 20.4 |
7 | 22.3 | 22.3 | 22.3 | 22.3 | 22.3 | 22.4 | 22.6 | 22.4 | 22.4 |
8 | 20.7 | 20.7 | 20.6 | 20.8 | 20.7 | 20.6 | 20.6 | 20.3 | 20.6 |
9 | 20.8 | 20.8 | 20.8 | 21.0 | 21.2 | 21.3 | 21.5 | 21.5 | 21.2 |
10 | 21.8 | 21.8 | 22.2 | 22.0 | 21.9 | 22.0 | 22.3 | 22.4 | 22.1 |
11 | 20.8 | 20.8 | 20.5 | 20.4 | 20.3 | 20.9 | 21.1 | 21.2 | 20.7 |
12 | 19.6 | 19.6 | 19.8 | 19.8 | 19.9 | 19.7 | 19.8 | 20.0 | 19.8 |
13 | 24.0 | 24.0 | 23.8 | 23.6 | 23.5 | 23.4 | 23.6 | 23.9 | 23.7 |
14 | 25.4 | 25.4 | 25.2 | 25.0 | 24.9 | 24.8 | 25.3 | 25.3 | 25.1 |
26 | 20.8 | 20.8 | 20.9 | 20.9 | 20.9 | 21.1 | 21.2 | 21.3 | 21.0 |
<tbody>
</tbody>