| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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! |
|
#2
|
|||
|
|||
|
Quote:
|
|
#3
|
|||
|
|||
|
Quote:
 hope this helps |
|
#4
|
|||
|
|||
|
Quote:
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| complex color fill conditions- if statements or complex formula? | Excel Discussion (Misc queries) | |||
| PLACINGS FROM HIGH TO LOW | Excel Worksheet Functions | |||
| Displaying winner/first four placings. | Excel Worksheet Functions | |||
| Complex Index Match Help (or at least complex to me) | Excel Discussion (Misc queries) | |||
| Formula for placings, using 4 times and greater than minimum time | Excel Worksheet Functions | |||
Linear Mode
