a row as below:
1, 1, 1, 1, 0.8, 0.9, 0.7, 0.5, 1, 0.8,0.6

I need to count all the continuous 1's from the left. Only the 1st
(from left) 4 1's need to be counted; the 9th 1 should not be counted.
Here the counting results should be 4.

I have several hundred rows like this. Please help to suggest a
formula.

Thanks.


--
yeedao
------------------------------------------------------------------------
yeedao's Profile: http://www.excelforum.com/member.php...o&userid=26268
View this thread: http://www.excelforum.com/showthread...hreadid=395619