http://www.cpearson.com/excel/Rank.aspx
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"shailen6882" wrote in message
...
total average result RANK
544 54.4 fail FAIL
593 59.3 pass 10
637 63.7 pass 6
611 61.1 fail FAIL
627 62.7 fail FAIL
632 63.2 pass 7
686 68.6 pass 2
653 65.3 pass 4
653 65.3 pass 4
713 71.3 pass 1
654 65.4 pass 3

i need rank for pass student's in sequence ...any
formula .........plzzzzz the problem is my formula give's the value
1,2,3,4,4,6,7,and 10 but what i need is 8 in place of 10 ......plz
solve...any one?