League Table
 

Hi All

Can anyone help please. I have a team of 8 manager's monthly results on a
spreadsheet for which I am trying to set up a league table . Their results
are downloaded from the internet and I use a link from one worksheet to
update another, the league table would then be updated on another worksheet
to show if their results have come in 1st, 2nd and so on. Is their a
formula which would help with this please?

Kath

Kath,

Is this the same as a sports league table?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"kathleen.smith10" wrote in message
...
Hi All

Can anyone help please. I have a team of 8 manager's monthly results on a
spreadsheet for which I am trying to set up a league table . Their
results
are downloaded from the internet and I use a link from one worksheet to
update another, the league table would then be updated on another
worksheet
to show if their results have come in 1st, 2nd and so on. Is their a
formula which would help with this please?

Kath

Do a "Sort" based on the column that contains the final results to list
in ascending 1, 2, 3 order. Be sure to highlight all the data before
sorting on the result column.


--
cycling-rod