Assuming you are using column A.

In Cell A502 your formula would be

=Countif(A1:a500,"<")/500

format this cell as a percentage.


--
CaptainQuattro
------------------------------------------------------------------------
CaptainQuattro's Profile: http://www.excelforum.com/member.php...o&userid=32763
View this thread: http://www.excelforum.com/showthread...hreadid=527001