Fast Solution to Problem: Ranking Formula in Excel

Ranking Formula in Excel

Dear Expert,

I want a ranking formula that will show my Students ranking as 1st, 2nd 3rd..............according to their obtained marks.
But here is a big condition that the students are failed will not be conformed with the other students who are passed.
sample:
Name      Marks        Grade         GPA       Position
 Mac         500              A              4              2nd
 Jac           575              F              0              4th
Noah        450              A-             3.50          3rd
Amit          550             A+             5              1st
Motro       540             F                0              5th

You can see here that the "passed" students are rowing first than that of "Failed" students.

Pls.
Help me.

Best regards.

Keys to the Problem Ranking Formula in Excel

Download SmartPCFixer for Free Now

Would this work for you for the first formula?
 
=IF(S9="F","",IF(RANK(R9,$R$9:$R$474)=COUNTIF($S$9:$S$474,"F"),1,RANK(R9,$R$9:$R$474)-COUNTIF($S$9:$S$474,"F")))
 
If value in column S on a row is F, then a zero-length string is output,
But if S is not an F then we determine the RANK() and compare it to the number of F's in column S, and subtract those from the RANK() value.  The special case is when RANK() is = number of F's, which gives a zero result, so we set that to 1, otherwise use
the calculated ranking for output.
 
I think the entire thing would look like this:
 
=IF(S9="F","",IF(RANK(R9,$R$9:$R$474)=COUNTIF($S$9:$S$474,"F"),1,RANK(R9,$R$9:$R$474)-COUNTIF($S$9:$S$474,"F")))&IF(S9="F","",IF(RANK(R9,$R$9:$R$474)=COUNTIF($S$9:$S$474,"F"),"st",MID("thstndrdth",MIN(9,2*RIGHT(RANK(R9,$R$9:$R$474)-COUNTIF($S$9:$S$474,"F"))*(MOD(RANK(R9,$R$9:$R$474)-COUNTIF($S$9:$S$474,"F")-11,200)>2)+1),2)))

Machine Throttling

• Go to the Start button.
• In the Search box, type "regedit" (without quotes) and press Enter.
• Look for the following registry key: "HKEY_LOCAL_MACHINE\SOFTWARE\ Microsoft\ SQMClient\Windows\DisabledSessions".
• On the right window pane, delete the subkey: "Machine Throttling".
• Restart your computer.

Another Safe way to Fix the Problem: Ranking Formula in Excel:

 

 

How to Fix Ranking Formula in Excel with SmartPCFixer?

1. Click the button to download Error Fixer . Install it on your system.  Run it, and it will scan your computer. The junk files will be shown in the list.

2. After the scan is done, you can see the errors and problems which need to be fixed.

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

Related: AVG Technologies ScriptHelperApi Class Add-on,After Running Sysem Restore My PC Running Windows 7 Home Premium Fails To Restart And On Manually Restarting Tells Me The Restore Has Failed Error Code Ox80070005,Access Data Base Engine DLL,After Changing Drive Letters W/ Disk Management In Windows 7 I Can No Longer View My Drives In "Computer",Automatically Deletes Mail When Exiting The Program,Not Able To Access Internet Explorer 8 Correctly.,Backup Error,Sign In Prob. With Games For Windows-live In Dirt 2,I'm Having Trouble Storing My Iphone Contacts In Windows Contacts,Dispositivo Microsoft Notebook Reciever V2.0 No Se Reconoce Dispositivo USB Error 43,Agentctl.dll registration on windows 8 64-bit,Full Cross Reference,How do I stop ads from flickering on Internet Explorer?,black changes to 87% when converting to spot color,Extra Zero's on Time in Excel.