Hi, I'm sure this will be pretty simple for the advanced users on this forum, but thanks vm in advance.
I would like an array formula that calculates the percentage of occurrences that a series of data makes a new high.
Column A - data (it rises and falls)
Column B - intermediate step to calculate when a new high is reached. Note the definition of a new high includes the entire series.
D1 - the answer required.
As always your help is much appreciated.
Thanks vm.
Excel 2013 32 bit
<colgroup><col style="width: 25pxpx"><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
<tbody>
</tbody>
I would like an array formula that calculates the percentage of occurrences that a series of data makes a new high.
Column A - data (it rises and falls)
Column B - intermediate step to calculate when a new high is reached. Note the definition of a new high includes the entire series.
D1 - the answer required.
As always your help is much appreciated.
Thanks vm.
Excel 2013 32 bit
A | B | C | D | |
---|---|---|---|---|
1 | 1 | 43% | ||
2 | 2 | h | ||
3 | 3 | h | ||
4 | 4 | h | ||
5 | 5 | h | ||
6 | 4 | |||
7 | 3 | |||
8 | 2 | |||
9 | 3 | |||
10 | 4 | |||
11 | 5 | |||
12 | 6 | h | ||
13 | 7 | h | ||
14 | 8 | h | ||
15 | 9 | h | ||
16 | 8 | |||
17 | 9 | |||
18 | 10 | h | ||
19 | 9 | |||
20 | 8 | |||
21 | 7 |
<colgroup><col style="width: 25pxpx"><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet1
Worksheet Formulas
<thead> </thead><tbody> </tbody> |
<tbody>
</tbody>