If the column you want the number in is A and the Column your data is in
is B put this formula in A. Then copy and paste it the the end of the
range you want numbered.
=COUNTIF($B$1:$B1,"""")

If there will be empty rows use this formula. It will cause the
numbering to skip any empty cells in column B.

=IF(B9"",COUNTIF($B$9:$B9,""""),"")

Hope it helps.


--
goober
------------------------------------------------------------------------
goober's Profile: http://www.excelforum.com/member.php...o&userid=19838
View this thread: http://www.excelforum.com/showthread...hreadid=484668