As the names suggest, they can be used to rank. They are useful for a use case such as finding the top customer or second, or third customer of each salesperson.


In case of Jack, we can see that RANK returned 1, 1, and 3. But that probably should have been two? If that’s the case…


So, if we wanted to see the customer with highest sales.