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
>