LinkBack URL
About LinkBacks
Hi,
Does anyone know how I can use a formula for inputting a persons position in a race for the scores appear automatically in the adjacent column. E.g 1st place 10 pts, 2nd 8pts etc?
Thanks in Advance
C
Converting rankings to scores for a sports spreadsheet
Hi,
Does anyone know how I can use a formula for inputting a persons position in a race for the scores appear automatically in the adjacent column. E.g 1st place 10 pts, 2nd 8pts etc?
Thanks in Advance
C
Try
=CHOOSE(C6,10,8,6,5,4,3,2,1)
or
=INDEX({10,8,6,5,4,3,2,1},C6)
Life's a spreadsheet, Excel!
Say thanks, Click *
=CHOOSE(C6,10,8,6,5,4,3,2,1) will do that
"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
Re: Converting rankings to scores for a sports spreadsheet
=CHOOSE(C6,10,8,6,5,4,3,2,1) worked perfectly!
Thanks to both of you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks