How about:
column D is 1,2,3,4,5,6,7,8,9
column E = countif($C$1:$C$11,d1) copied down through e9.

Is that what you are looking for?


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=377805