how to get points to be automatically placed then put points

Verstatility Shows Original 2014.xlsx
In the score column I want it to take the highest score and place them 1st thru however many there are in order

then


When the PLACE says "1" I want the POINTS to automatically say "10"
for 1 it should be 10
2 is 9
3 is 8
4 is 7
5 is 6
6 is 5
7 is 4
8 is 3
9 is 2
10+ is 1

hope that makes sense to y'all.

http://www.excelforum.com/excel-form...ml#post3735209

Hi and welcome to the forum

To begin with, you can simplify the formula in AA to this...
=SUMIF($D$2:$Z$2,"points",D3:AA3)

Not sure if this is what you want, but may be it will help you in the direction? I am a little unsure which columns you want to test against.

=LARGE($F$3:$F$26,ROW(A1))

copied down will "rank" the points in F