Hello,I am trying to make a points system for a competition.if in log lift i3 to i12 i have a total after 4 rounds.if in example i3 is the highest then it gets 10pts in j3 then next highest gets 8etc.Please see attached.Thanks.
Hello,I am trying to make a points system for a competition.if in log lift i3 to i12 i have a total after 4 rounds.if in example i3 is the highest then it gets 10pts in j3 then next highest gets 8etc.Please see attached.Thanks.
Last edited by giant; 06-06-2010 at 02:32 PM.
for your example
=CHOOSE(RANK(I3,$I$3:$I$12),10,8,7,6,5,4,3,2,1) dragged down
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Works great.Thank you Martin d wilson.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks