Sign In


Join the 5 Minute Guide community to share your own tutorials and participate in forum conversations!



Rank and Order Data Automatically in Excel


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)

Tutor Bio

Alternative Text

In real life Mike is a husband and father of 2. He also develops websites (like this one) and makes overwhelming amounts of data understandable using Excel, Numbers, Access, etc.