Hi
Taking advantage of Gary's formula, I just added the "IF(Pass/Fail)" the OP
wants.
Hope you don't mind Gary.
Regards
John

=IF(C2:C12="pass",1+SUMPRODUCT(($C$2:$C$12="pass") *($B$2:$B$12B2)),"Fail")
"Gary Keramidas" wrote in message
...
this may get you close. it should rank the fails after the passes.

=1+SUMPRODUCT(($C$2:$C$12="pass")*($B$2:$B$12B2))

--


Gary Keramidas
Excel 2003


"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?