01-09-2005, 05:06 AM
|
|
|
|
Re: 1st, 2nd, 3rd Place etc.....
Be careful !
That third argument ( ,1 ) *may* not be necessary.
=RANK(B1,$B$1:$B$25)
Will rank the *highest* score as number "1".
=RANK(B1,$B$1:$B$25,1)
Will rank the *lowest* score as number "1" (golf).
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"William" <willwest22@yahoo.com> wrote in message
news:ufSpEif9EHA.3828@TK2MSFTNGP09.phx.gbl...
> Hi John
>
> Have a look at Excel's "RANK" formula
> eg =RANK(B1,B1:B25,1)
>
>
> --
> XL2002
> Regards
>
> William
>
> willwest22@yahoo.com
>
> "JohnT" <anonymous@discussions.microsoft.com> wrote in message
> news:15d101c4f5f7$2a234be0$a401280a@phx.gbl...
> | I have an idea how to do this but it requires a series of
> | nested ifs and i'm sure there is a better way......in
> | column A i have a list of names, column B is their scores
> | and in C i would like to rank them in 1st, 2nd, 3rd etc....
> | any ideas????
> |
> | (thanks in advance)
>
>
>
|