Have you tried just sorting the data by scores in decending order?

Don Psitulka


"adeel afzal via OfficeKB.com" wrote in message
...

i have a school marks sheet. i calculate total no. percentage. grade.. but
i
dont understand how can i calculate positions...
i tried many time but i cant understand how can i work with ranks. coz i
find
the highest marks with max function and lowest with the min function but
plz
tell me how can i find second highest and third and so on.......
plz help me

like . 2nd 3rd 4th........

M Adeel Afzal
Thanks in advance....