Excel formula for ranking sorting criteria

[Luxio1997]

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...

[#2]

Without sample data it is really hard to advise best formula. SORTBY() function may help you. Attach a sample and show your desired output.

[#3]

How do I attach a sample?

[#4]

@Luxio1997 

If you cannot attach a workbook to a reply, you can make it available through OneDrive, Google Drive, Dropbox or similar.

[#5]

This is the file:

https://1drv.ms/x/s!AmGASNd_GSMJgR7QxIy6WNXoAT7v?e=BVidlg

[#6]

@Luxio1997 

If you have Microsoft 365 or Office 2021, enter the following formula in a cell. It will automatically spill to cells to the right and below.

=SORT(A3:J8, {10,2,9,7,8}, {-1,-1,-1,-1,-1})

[#7]

I have Microsoft Office 2013

[#8]

@Luxio1997 

In that case, I'd stay with what you already had.

[#9]

Ok thanks