plz can u solve this

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

 

[Don Guillett]

http://www.cpearson.com/excel/Rank.aspx

 

[shailen6882]

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






- Show quoted text -

thanx,but it dosen't help me to solve my problem i go through this
page as well...thanx again if u have other pages plz inform me..thanx

 

[Gary Keramidas]

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))

 

[John]

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

 

[Gary Keramidas]

don't mind, i just put it together quickly without much testing. not sure it
will do what the op wants or not.

 

[John]

Lets hope he does reply with a answer. To many just don't acknowledge.
John

 

[shailen6882]

Lets hope he does reply with a answer. To many just don't acknowledge.
John







- Show quoted text -

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

 

[shailen6882]

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 -

thanx ................i got what i want ...........a many many thanx
too u ..........

 

[John]

You're welcome
John

Lets hope he does reply with a answer. To many just don't acknowledge.
John







- Show quoted text -

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