The CUBERANKEDMEMBER function in Excel returns the rank of a specified value in a series of values, based on a supplied ranking function. The ranking function can be a function such as AVERAGE, MAX, or MIN, or a built-in Excel function such as VLOOKUP. The CUBERANKEDMEMBER function can be used in a variety of ways, including:
-To rank a series of numbers
-To rank a series of text values
-To rank a series of dates
-To rank a series of Boolean values
-To rank a series of error values
The syntax of CUBERANKEDMEMBER in Excel is as follows:
The function takes three arguments:
array: The array of numbers to rank ranking_column: The column in the array that contains the ranking information index: The position of the number in the ranking_column
If the ranking_column argument is omitted, the function will rank the numbers in ascending order.
The Excel CUBERANKEDMEMBER function takes a list of numbers and ranks them in order from smallest to largest. The function then returns the rank of the given number within the list. For example, if the list contains the numbers 1, 2, 3, 4, 5, the rank of 5 would be 1, since it is the smallest number in the list.
There are a few occasions when you should not use CUBERANKEDMEMBER in Excel. One reason you might not want to use CUBERANKEDMEMBER is if you have a large data set. Another reason you might not want to use CUBERANKEDMEMBER is if you are trying to calculate a rank that is not in the data set.
There are a few similar formulae to CUBERANKEDMEMBER in Excel. One is CUBEMEMBER, which returns the member of a cube that is specified by a position number. Another is CUBERANK, which returns the rank of a member in a cube. Another is CUBESET, which sets the members of a cube. Finally, there is CUBESUM, which returns the sum of the members in a cube.