One way is to sort from largest to smallest and write numbers by each another is to use RANK FX
This Excel Q&A shows how to use the RANK function to rank customers by their revenue.
Below is the video from the youtube page for ExcelMonster.com