YAY!!!
thats what it was, drag the little box in the bottom right corner!!
THANKS!
"pinmaster" wrote:
You can try something like this:
=IF(B1="","",COUNTA($B$1:B1)
copy down....or if there are no gabs in your list simply double click
on the lower right corner of the cell.
HTH
JG
--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=497944