ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   plz solve this i need solution (https://www.excelbanter.com/excel-discussion-misc-queries/259886-plz-solve-i-need-solution.html)

shailen6882

plz solve this i need solution
 
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
what i need is i would like to give rank to only pass student not to
fail student ...n rank in sequence too...means see the problem it
give's value 1,2,3,4,4,5,6,7,and 10 . but actully i need 8 in place of
10.plz solve .....


All times are GMT +1. The time now is 12:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com