plz can u solve this

  • Thread starter Thread starter shailen6882
  • Start date Start date
S

shailen6882

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?
 
this may get you close. it should rank the fails after the passes.

=1+SUMPRODUCT(($C$2:$C$12="pass")*($B$2:$B$12>B2))
 
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$12>B2)),"Fail")
 
don't mind, i just put it together quickly without much testing. not sure it
will do what the op wants or not.
 
Lets hope he does reply with a answer. To many just don't acknowledge.
John







- Show quoted text -
Click to expand...

thanks boss u have brilliant brain n i got what i want .......thanx
again ........thanx again ............
 
don't mind, i just put it together quickly without much testing. not sureit
will do what the op wants or not.

--

Gary Keramidas
Excel 2003







- Show quoted text -
Click to expand...

thanx ................i got what i want ...........a many many thanx
too u ..........
 
You're welcome
John
Lets hope he does reply with a answer. To many just don't acknowledge.
John







- Show quoted text -
Click to expand...

thanks boss u have brilliant brain n i got what i want .......thanx
again ........thanx again ............
 
Back
Top