Forum Discussion
Solved
Counting in sequence with skipping
Hi, I would like to set up a formula where the formula counts sequential (1,2,3,4,5...) on any "Yes" entry, but skips any "No" answer in a column. I would like to be able to count of the first 110 "...
OliverScheurich This is awesome, thank you so much, it works beautiful! Vielen Dank für die schnelle Hilfe 🙂
As variant
=LET(
flag, --(data="Yes"),
count, SCAN(0,flag, LAMBDA(a,v, a+v)),
IF(flag, count, "")
)