Forum Discussion
Excel formula for ranking sorting criteria
Hello everyone,
I have prepared an excel sheet to update a fantasy football ranking.
I couldn't find a formula that would allow me to automatically sort the tournament teams based on the following criteria:
1) Points
2) Total Points
3) Goals For
4) Goals Against
5) Goal Difference
I found an alternative (in my opinion rather superficial): create a coefficient that adds the various criteria (each divided by a multiple of 10). Therefore I have ordered the ranking according to the coefficient.
I still hope that someone can enlighten me with a formula!!!
PS. It would be easier if I could attach the file, but I think that's not possible...
- Without sample data it is really hard to advise best formula. SORTBY() function may help you. Attach a sample and show your desired output.
- How do I attach a sample?
If you cannot attach a workbook to a reply, you can make it available through OneDrive, Google Drive, Dropbox or similar.
