K
Kelvin
If there's a column with 100 "yes" or "no". I wanna calc the number of gaps
between each yes.
For example:
A1=yes
A2=no
A3=no
A4=yes
A5=no
A6=yes
Therefore, the output i wanna achieve is there is a maximum of 3 gaps
between the yes and no (between A1 to A4) while the minimum gaps will be 2
(A4 to A6)
between each yes.
For example:
A1=yes
A2=no
A3=no
A4=yes
A5=no
A6=yes
Therefore, the output i wanna achieve is there is a maximum of 3 gaps
between the yes and no (between A1 to A4) while the minimum gaps will be 2
(A4 to A6)