Hi steve,

I've managed to do what you said, it worked brilliantly!! But then
about 2 hours ago the boss decided to change the way he wanted to
assign points....

so for every columns/catergoy the person with the highest score gets
10, then its goes down to 8, 4, 3, 2, 1 - still showing 1st, 2nd and
3rd.

What i have done, is inserted a column after every catergoy and worked
out the Min, median and max - would that give me a true figure?

If not is there any other way to do it?

Thanks


--
harpscardiff
------------------------------------------------------------------------
harpscardiff's Profile: http://www.excelforum.com/member.php...o&userid=25960
View this thread: http://www.excelforum.com/showthread...hreadid=571715