Hi, thanks for your help in advance!
I would love some help making a slight tweak to an almost correct formula.
I would like to count the number of drawdown periods in a row. Column F is almost right but is out by 1 for all calculations except for the very last (row 58).
The answers I would like are in Column H.
Much appreciated.
Excel 2013 32 bit
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
<tbody>
</tbody>
<tbody>
</tbody>
I would love some help making a slight tweak to an almost correct formula.
I would like to count the number of drawdown periods in a row. Column F is almost right but is out by 1 for all calculations except for the very last (row 58).
The answers I would like are in Column H.
Much appreciated.
Excel 2013 32 bit
A | B | C | D | E | F | G | H | |
---|---|---|---|---|---|---|---|---|
1 | Data | Draw (%) | Draw (Size) | Max Draw per phase | Recovery Period | 1) Max Draw per Phase (%) | 2) Draw Length | |
2 | ||||||||
3 | 1 | 0% | 0 | - | - | - | - | |
4 | 2 | 0% | 0 | - | - | - | - | |
5 | 3 | 0% | 0 | - | - | - | - | |
6 | 2 | -33% | -1 | - | - | - | - | |
7 | 1 | -67% | -2 | - | - | - | - | |
8 | 0 | -100% | -3 | - | - | - | - | |
9 | -1 | -133% | -4 | - | - | - | - | |
10 | -2 | -167% | -5 | - | - | - | - | |
11 | -3 | -200% | -6 | - | - | - | - | |
12 | -1 | -133% | -4 | - | - | - | - | |
13 | 3 | 0% | 0 | -200% | 8 | -200% | 7 | |
14 | 5 | 0% | 0 | - | - | - | - | |
15 | 10 | 0% | 0 | - | - | - | - | |
16 | 12 | 0% | 0 | - | - | - | - | |
17 | 15 | 0% | 0 | - | - | - | - | |
18 | 20 | 0% | 0 | - | - | - | - | |
19 | 18 | -10% | -2 | - | - | - | - | |
20 | 16 | -20% | -4 | - | - | - | - | |
21 | 8 | -60% | -12 | - | - | - | - | |
22 | 7 | -65% | -13 | - | - | - | - | |
23 | 6 | -70% | -14 | - | - | - | - | |
24 | 5 | -75% | -15 | - | - | - | - | |
25 | 4 | -80% | -16 | - | - | - | - | |
26 | 3 | -85% | -17 | - | - | - | - | |
27 | 2 | -90% | -18 | - | - | - | - | |
28 | 1 | -95% | -19 | - | - | - | - | |
29 | 0 | -100% | -20 | - | - | - | - | |
30 | -2 | -110% | -22 | - | - | - | - | |
31 | -1 | -105% | -21 | - | - | - | - | |
32 | 0 | -100% | -20 | - | - | - | - | |
33 | 1 | -95% | -19 | - | - | - | - | |
34 | 2 | -90% | -18 | - | - | - | - | |
35 | 3 | -85% | -17 | - | - | - | - | |
36 | 4 | -80% | -16 | - | - | - | - | |
37 | 5 | -75% | -15 | - | - | - | - | |
38 | 6 | -70% | -14 | - | - | - | - | |
39 | 7 | -65% | -13 | - | - | - | - | |
40 | 8 | -60% | -12 | - | - | - | - | |
41 | 9 | -55% | -11 | - | - | - | - | |
42 | 10 | -50% | -10 | - | - | - | - | |
43 | 25 | 0% | 0 | -110% | 25 | -110% | 24 | |
44 | 19 | -24% | -6 | - | - | - | - | |
45 | 18 | -28% | -7 | - | - | - | - | |
46 | 18 | -28% | -7 | - | - | - | - | |
47 | 17 | -32% | -8 | - | - | - | - | |
48 | 16 | -36% | -9 | - | - | - | - | |
49 | 15 | -40% | -10 | - | - | - | - | |
50 | 14 | -44% | -11 | - | - | - | - | |
51 | 13 | -48% | -12 | - | - | - | - | |
52 | 12 | -52% | -13 | - | - | - | - | |
53 | 11 | -56% | -14 | - | - | - | - | |
54 | 10 | -60% | -15 | - | - | - | - | |
55 | 9 | -64% | -16 | - | - | - | - | |
56 | 8 | -68% | -17 | - | - | - | - | |
57 | 7 | -72% | -18 | - | - | - | - | |
58 | 6 | -76% | -19 | -76% | 15 | -76% | 15 |
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Forum Post #1
Worksheet Formulas
<thead> </thead><tbody> </tbody> |
<tbody>
</tbody>
Array Formulas
<thead> </thead><tbody> </tbody> Note: Do not try and enter the {} manually yourself |
<tbody>
</tbody>