Good to see it works for you, and thanks for the response

--

Wrote:
Bryan Hessey wrote:
testing column A, and using column C as a helper column,
in C2 put
=IF(A2<"","",IF(C1="",1,C1+1))
and in B2 put
=IF(A3="","",C2)
and formula drag B2 and C2 down to cover your data.

Well, I think I screwed up my example, but I got the idea.
Works great! 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=533202