Rank function

[Nattu Jumbo]

Hi,
I have a little problem with rank function.The thing is as
a teascher i have to give ranks for each student. But if
70 is the highest and is got by two students, second place
does not exist. So I want to give the second lower student
the 2nd place. How can I do this?
In need,
bye

 

[Bob Phillips]

Nattu,

Use this formula to rank them.

=RANK(B2,$B$2:$B$40)+COUNTIF($B$2:B2,B2)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)