Join the 5 Minute Guide community to share your own tutorials and participate in forum conversations!
The trick to automatically ranking your data is to combine the RANK function and the VLOOKUP function so that you create an auto sort based on rank. Save yourself the annoyance of having to re-sort your data every time something changes by using this trick.
This trick should work in Excel and Google Spreadsheets
This video was made using Screenflow by Telestream (for Mac)