In B1 put

=IF(A1<1,"",1)

In B2 put

=IF(A2<1,"",1+IF(B1="",0,B1))

and formula drag that down as far as you need.

--

Ed Wrote:
Hello,

In Column A, I have this list of 1's and empty cells*, i would like to
have
in column B a function that gives me the next result:

*A1=1 B=1
*A2=1 B=2
*A3=1 B=3
*A4="" B=""
*A5=1 B=1
*A6=1 B=2
*A7="" B=""
*A8=1 B=1
*A9=1 B=2
*A10=1 B=3

It would be like a counter that tells me the number of times 1 has
appeared
so far, but when it reaches: "" it restarts and goes on again.

,thanks


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=532927