Guys and Girls,

I have an excel sheet where I am trying to:

one: data sort 7 columns according to the sixth column that has the placings! I have manged to rank the sixth column from highest to lowest from column 5, obvisouly in a random order.


two: according to the 6th column placings, place points according to their placing in the 7th column. I hope thats makes sense!
ie: who ever placed first gets 100 points, 2nd 80 points and so forth!


thanks guys and girls in advance!