Another forum user helped me out with this formula. It works great for
my application, but I don't completely understand it. Particularly, I
am unsure of the use of the brackets at the beginning and end of the
formating. Can someone clear this up for me? Thanks, Jason

{=SUM(IF(B2B$2:B$21,1/COUNTIF(B$2:B$21,B$2:B$21)))+1+ROW()/10^10}


--
daddioja
------------------------------------------------------------------------
daddioja's Profile: http://www.excelforum.com/member.php...o&userid=35024
View this thread: http://www.excelforum.com/showthread...hreadid=550439