Quote:
Originally Posted by phil2026
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!
|
Might be an idea to post a dummy example workbook for us to have a look at.