Rank Function

I don’t understand this rank function. I need some help please. I have
looked up the site that has been recommended
(http://www.cpearson.com/excel/rank.htm) and that helped somewhat, but I
guess I just don’t understand all of it.

I would like to use the function to see a set of numbers in column and rank
those numbers in ascending order. My function looks like:
=COUNT(N$2:N$13)-(RANK(N2,N$2:N$5)+COUNTIF(N$2:N2,N2))+2, but it’s not
working as I thought that it should. What am I missing?

Thanks

try Chip Person web page

http://www.cpearson.com/excel/rank.htm

hth
regards from Brazil
Marcelo

"Jeana" escreveu:

> I don’t understand this rank function. I need some help please. I have
> looked up the site that has been recommended
> (http://www.cpearson.com/excel/rank.htm) and that helped somewhat, but I
> guess I just don’t understand all of it.
>
> I would like to use the function to see a set of numbers in column and rank
> those numbers in ascending order. My function looks like:
> =COUNT(N$2:N$13)-(RANK(N2,N$2:N$5)+COUNTIF(N$2:N2,N2))+2, but it’s not
> working as I thought that it should. What am I missing?
>
> Thanks
>

OP mentioned that page as useless for her needs!

Cheers
--
AP

"Marcelo" <[email protected]> a écrit dans le message de
news: [email protected]...
> try Chip Person web page
>
> http://www.cpearson.com/excel/rank.htm
>
> hth
> regards from Brazil
> Marcelo
>
> "Jeana" escreveu:
>
>> I don't understand this rank function. I need some help please. I have
>> looked up the site that has been recommended
>> (http://www.cpearson.com/excel/rank.htm) and that helped somewhat, but I
>> guess I just don't understand all of it.
>>
>> I would like to use the function to see a set of numbers in column and
>> rank
>> those numbers in ascending order. My function looks like:
>> =COUNT(N$2:N$13)-(RANK(N2,N$2:N$5)+COUNTIF(N$2:N2,N2))+2, but it's not
>> working as I thought that it should. What am I missing?
>>
>> Thanks
>>

Ops !!!! sorry friends

i didn't have noticed

regards

"Ardus Petus" escreveu:

> OP mentioned that page as useless for her needs!
>
> Cheers
> --
> AP
>
> "Marcelo" <[email protected]> a écrit dans le message de
> news: [email protected]...
> > try Chip Person web page
> >
> > http://www.cpearson.com/excel/rank.htm
> >
> > hth
> > regards from Brazil
> > Marcelo
> >
> > "Jeana" escreveu:
> >
> >> I don't understand this rank function. I need some help please. I have
> >> looked up the site that has been recommended
> >> (http://www.cpearson.com/excel/rank.htm) and that helped somewhat, but I
> >> guess I just don't understand all of it.
> >>
> >> I would like to use the function to see a set of numbers in column and
> >> rank
> >> those numbers in ascending order. My function looks like:
> >> =COUNT(N$2:N$13)-(RANK(N2,N$2:N$5)+COUNTIF(N$2:N2,N2))+2, but it's not
> >> working as I thought that it should. What am I missing?
> >>
> >> Thanks
> >>
>
>
>

<<<"but it’s not working as I thought that it should.">>>

Just exactly how *should* it work?

Run these 2 elementary rank formulas, and post back with what they're *not*
doing, that you would like them to do.
Maybe that way a better understanding of your wishes can be achieved.

=RANK(N2,N$2:N$5)
=RANK(N2,N$2:N$5,1)
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Jeana" <[email protected]> wrote in message
news:[email protected]...
>I don’t understand this rank function. I need some help please. I have
> looked up the site that has been recommended
> (http://www.cpearson.com/excel/rank.htm) and that helped somewhat, but I
> guess I just don’t understand all of it.
>
> I would like to use the function to see a set of numbers in column and
> rank
> those numbers in ascending order. My function looks like:
> =COUNT(N$2:N$13)-(RANK(N2,N$2:N$5)+COUNTIF(N$2:N2,N2))+2, but it’s not
> working as I thought that it should. What am I missing?
>
> Thanks
>