Posts by Fábio Linhares • 109 points
1 post
-
0
votes1
answer791
viewsQ: How to count consecutive values in Excel?
Right now I have this formula that calculates consecutive values: =SE(AB5=0;0;SE(OU(E(AB4>=100;AB5>=100);E(AB4<=-100;AB5<=-100));AC4+1;1)) Basically she does this: 0 0 0 0 -110 1 -110 2…
excelasked Fábio Linhares 109