|
Re: 1st, 2nd, 3rd Place etc.....
Take a look at http://www.xldynamic.com/source/xld.RANK.html
--
HTH
RP
(remove nothere from the email address if mailing direct)
"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)
|