Placing players 1st, 2nd, 3rd etc....

My problem is RANK function will not work under this situation.
I need to place players 1st, 2nd, 3rd, etc. on a score sheet. 1 win = 2 points, Loss = 0
To break ties (Which are many) there is a shot differential (Shots For - Shots Against).
There are 3 games w/ a total of 6 game points possible.
Any team w/ 6 game points is automatically above anybody who lost a game (ie; 4 game points, and 2 game points to 0).
Shot differential is added to the game points to determine placement of the ties. Unfortunately, several of the teams who lost games have total points w/ shot differential higher than the teams who lost no games (ie; 6 game points).
It's a very basic spreadsheet that I made, BUT.....
I'm trying to use the RANK function, which is out of the question.

Any suggestions?

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

May be there are teams with same games point, same Shots diff, but different Ends Won.
This will break down the difference, follow the order of upper priority
In AU8 then drag down:

Please Login or Register  to view this content.

Cross-posted at: https://www.mrexcel.com/forum/excel-...variables.html
Please read Excel Forum's Cross-Posting policy in rule 8: http://www.excelforum.com/forum-rule...rum-rules.html

Originally Posted by BussellT

I initially posted in several forums looking for an answer.

In that case, you are required both here and at Mr Excel to provide cross-post links to ALL of the forums concerned. You should also ensure you comply with whatever cross-posting rules those other forums have, too.