## Complex Ranking in ms excel

Dear Experts,
I have a result sheet for my students and a specimen marks as:

roll          Name of students     English           Math              physics     total      Grade           GPA
1             Mac                            30                 50                   60          140          F                4.5
2             Jac                              50                 35                   40          125         A                 3.5
3              Mac                            30                 50                   60         150          F                4.5                                                                        4             Jac                              50
35                   40          145         A                 3.5

But my question is- after being a failed student he(roll no.
3) can not go ahead of 'all subjects passed students' though the roll no.
3 is getting highest marks here.
his position would be after al subjcts passed students.
he will be ranking with students
who are failed.

I am using a general "Ranking formula" like    =RANK(S11,\$S\$9:\$S\$464)&MID("thstndrdth",MIN(9,2*RIGHT(RANK(S11,\$S\$9:\$S\$464))*(MOD(RANK(S11,\$S\$9:\$S\$464)-11,200)>2)+1),2)).
it counts all the students considering no 'pass' or ''fail".

thanks.

## Solutions to the Problem Complex Ranking in ms excel

Ok Sorry to take so long.
I added four helper columns as you can see.
I named them so that if you include them in another sheet you can do the same thing.

The formulas are shown below.

Cell-->
Cell formula

W9
=IF(T9<>"F",S9,"")

X9
=IFERROR(RANK(S9,rngFail)+MAX(RnkPass),"")

Y9
=IFERROR(RANK(W9,rngPass),"")

Z9
=IFERROR(RANK(S9,rngFail)+MAX(RnkPass),"")

V9
=IFERROR(IF(T9<>"F",Y9&CHOOSE(AND(Y9<>11,12,13)*MIN(4,MOD(Y9,10))+1,"th","st","nd","rd","th"),Z9&CHOOSE(AND(Z9<>11,12,13)*MIN(4,MOD(Z9,10))+1,"th","st","nd","rd","th")),"")

HTH
Peter

## Windows Error Reporting - To Fix Complex Ranking in ms excel

1. Go to Start button.
2. Open Control Panel.
3. Go to Windows Error Reporting.
4. Click on System and Maintenance, then click Problem Reports and Solutions.
5. Next, click Change Settings located on the left side panel of the Problem Reports and Solutions window.
6. Select an option to configure how you want Windows to look for a solution to your problems. You may allow Windows to do it automatically or ask you every time to check if problem occurs.
8. Select Off to turn off Error Reporting.

## Recommended Method to Repair the Problem: Complex Ranking in ms excel:

### How to Fix Complex Ranking in ms excel with SmartPCFixer?

1. Click the button to download SmartPCFixer . Install it on your system.  Open it, and it will perform a scan for your computer. The junk files will be shown in the scan result.

2. After the scan is finished, you can see the errors and problems need to be repaired. Click Fix All.

3. The Repair part is done, the speed of your computer will be much higher than before and the errors have been fixed. You can also use other functions in this software. Like dll downloading, windows updating and print spooler error repair.