Let's say I have a column with the following values:
...
-0.26%
-0.09%
0.00%
0.00%
-0.25%
-0.82%
-1.08%
-1.09%
-0.98%
-1.27%
-1.04%
-1.78%
-3.46%
-2.80%
0.00%
-1.39%
...
Is there a formula that can:
Identify the MIN (-3.46%), then count the # of consecutive negative #s from above the MIN until it reaches it (including the MIN). In this example, I'd like the result of the formula to be 9.
Hopefully this request makes sense. Thanks in advance!
...
-0.26%
-0.09%
0.00%
0.00%
-0.25%
-0.82%
-1.08%
-1.09%
-0.98%
-1.27%
-1.04%
-1.78%
-3.46%
-2.80%
0.00%
-1.39%
...
Is there a formula that can:
Identify the MIN (-3.46%), then count the # of consecutive negative #s from above the MIN until it reaches it (including the MIN). In this example, I'd like the result of the formula to be 9.
Hopefully this request makes sense. Thanks in advance!