Highest value function and so forth =- help

[Scott]

Ok - trying to do a sort of league table and have a comment at the end of
each line eg 1st, 2nd etc

Heres approx layout

Team 1 - 36pts
Team 2 - 48 pts
Team3 - 16 pts

So - what I want is basically

Team 1 - 36pts 2nd
Team 2 - 48 pts 1st
Team3 - 16 pts 3rd

Any idea how I do this with a function as the league table is in excel.?

Scott

 

[JulieD]

Hi Scott

firstly combining numbers & text in a cell (e.g. 36pts) makes it difficult
to perform functions on if you have actually typed in the pts bit .. the
best way to deal with something like this, is to type in the number (36) and
use format / cells - numbers tab, custom to format it to show the "pts"
bit - to do this in the custom box type
Generalpt\s

this will then allow you to perform mathematical functions on the number
while looking "nice".

to then answer your question you can use the RANK() to return their position
in a list.
say the scores are entered as numbers and formatted as per the above in
cells B1:B3
in C1 type
=RANK(B1,$B$1:$B$3) and fill down

Hope this helps
Cheers
JulieD