|
plz can u solve this
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? |
plz can u solve this
On Mar 25, 7:52*pm, "Don Guillett" wrote:
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?- Hide quoted text - - 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 |
plz can u solve this
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? |
plz can u solve this
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? |
plz can u solve this
don't mind, i just put it together quickly without much testing. not sure it
will do what the op wants or not. -- Gary Keramidas Excel 2003 "John" wrote in message ... 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? |
plz can u solve this
Lets hope he does reply with a answer. To many just don't acknowledge.
John "Gary Keramidas" wrote in message ... don't mind, i just put it together quickly without much testing. not sure it will do what the op wants or not. -- Gary Keramidas Excel 2003 "John" wrote in message ... 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? |
plz can u solve this
On Mar 25, 11:44*pm, "John" wrote:
Lets hope he does reply with a answer. To many just don't acknowledge. John "Gary Keramidas" wrote in message ... don't mind, i just put it together quickly without much testing. not sure it will do what the op wants or not. -- Gary Keramidas Excel 2003 "John" wrote in message ... 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?- Hide quoted text - - Show quoted text - thanks boss u have brilliant brain n i got what i want .......thanx again ........thanx again ............ |
plz can u solve this
On Mar 25, 11:20*pm, "Gary Keramidas" wrote:
don't mind, i just put it together quickly without much testing. not sure it will do what the op wants or not. -- Gary Keramidas Excel 2003 "John" wrote in message ... 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?- Hide quoted text - - Show quoted text - thanx ................i got what i want ...........a many many thanx too u .......... |
plz can u solve this
You're welcome
John "shailen6882" wrote in message ... On Mar 25, 11:44 pm, "John" wrote: Lets hope he does reply with a answer. To many just don't acknowledge. John "Gary Keramidas" wrote in message ... don't mind, i just put it together quickly without much testing. not sure it will do what the op wants or not. -- Gary Keramidas Excel 2003 "John" wrote in message ... 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?- Hide quoted text - - Show quoted text - thanks boss u have brilliant brain n i got what i want .......thanx again ........thanx again ............ |
| All times are GMT +1. The time now is 11:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com