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 follow...
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.
- This is the file:
https://1drv.ms/x/s!AmGASNd_GSMJgR7QxIy6WNXoAT7v?e=BVidlgIf 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})
- I have Microsoft Office 2013