xeven_
Active Member
- Joined
- Jan 20, 2012
- Messages
- 302
I have data in coulmns C and D. I want to calculate the percent difference between th ehighest and lowest valueevery five days and have that value populate in the adjacent column/cell E. Is there a formula to help me do this? As in this example the percent change form the highest vale 8.2 to the lowest 6.62 is -19%. I was hoping to get a formula that can populate in E and scroll down to keep a running analysis of every five days. This is daily data with a weekly hopefully relevent metric.
<colgroup><col><col span="4"></colgroup><tbody>
</tbody>
Monday, April 2, 2012 | 11% | 8.2 | 7.4 | |
4/3/2012 | 4% | 7.8 | 7.5 | |
4/4/2012 | 6% | 7.77 | 7.31 | |
4/5/2012 | 2% | 7.55 | 7.37 | |
4/9/2012 | 19% | 7.89 | 6.62 | -19% |
<colgroup><col><col span="4"></colgroup><tbody>
</tbody>