ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Complex Placings (https://www.excelbanter.com/excel-worksheet-functions/446239-complex-placings.html)

phil2026
Complex Placings
 
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!

Spencer101
Quote:
Originally Posted by phil2026 (Post 1602405)
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.

phil2026
Quote:
Originally Posted by Spencer101 (Post 1602411)
Might be an idea to post a dummy example workbook for us to have a look at.


hope this helps

phil2026
Quote:
Originally Posted by phil2026 (Post 1602447)


hope this helps
Can anyone help?


All times are GMT +1. The time now is 03:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com