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" <[email protected]> wrote in message
news:[email protected]...
> 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