Try using a variation of this:

A2: =MAX($A$1:OFFSET(A2,-1,,,))+1

Copy that cell anywhere in column A. It will ignore blanks and text
when incrementing.

Does that help?
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=467475