If you’ve ever been confused by Excel’s three different ranking functions, you aren’t alone. A rank is a rank, right? But they actually differ in how they handle ties and which versions of Excel they work in. Here is how to choose the right one for your next spreadsheet.