Quote:
Originally Posted by westcoastgsr
Thanks the formula works. But the names are not sperated but they are sorted alphabetically. So the problem is the results blend together. For example:
Bob n
Bob n
Bob n
Ted n
Ted n
Then it say there was 4 in a row.
|
you can add another "if (A2=A3, x, 0) function infront of the formula
> C3 = IF(A2=A3, IF(B3="N", IF(C2>=1, IF(B2=B3, C2+1, 0), IF(B2=B3, 2, 0)), 0), 0)
Btw..just notice the formula I posted is "cumulative" (i.e. if you miss 4 in a row, it will show both 2, 3, and 4 in the results)
depending on how you want your result....you might need to add another function or another column to take out the cumulative results.