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