One of the first things you learned in Excel were the functions for determining the maximum (MAX) and minimum (MIN) of a range. Also, sorting a range can easily determine the order of its members, from the smallest to the largest or in the opposite direction. But, since it’s not convenient to manually count the members’ ranking, we can use one of the Excel ranking functions.