Thanks for the quick reply!

That works to my example, but not for the actual sheet. I get this
error "#DIV/0!". The actual the cells contain names wich that formula
doesn't seem to like. Column A contains names and column C contains
ranks. I need to know the % of people with a rank. The number of people
in column A will change from time to time.
This is a little more difficult than I thought!

In a nutshell:
I need E1 to display the % of cells in column C that contain data as
compared to column A.


--
matthewst
------------------------------------------------------------------------
matthewst's Profile: http://www.excelforum.com/member.php...o&userid=20340
View this thread: http://www.excelforum.com/showthread...hreadid=483610