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.