Thanks Ron,
I put in your formula and it works with one exception. This is kind of
hard to explain. there are three rows for every name in the list (75
names, 225 rows). like i said earlier every third row is an average of
the above two. Not everyone will have a score, some will have one, some
will have two. The problem with your previous formula is that if there
are 10 names and 5 have 2 scores each and the other 5 have 0, it shows
100% when it should be 50%. no one will have a score in the second row
without a score in the first row. my suggestion would be to have it
only look at the first of the three rows for each person; but of course
i'm not skilled with formulas enough to change the one that you
provided.
Please help me change the previous formula to these specifications.
thanks.


--
ForSale
------------------------------------------------------------------------
ForSale's Profile: http://www.excelforum.com/member.php...o&userid=11896
View this thread: http://www.excelforum.com/showthread...hreadid=277223