Excel Function : CUBERANKEDMEMBER
Returns the nth, or ranked, member in a set. Use to return one or more elements in a set, such as the top sales performer or top 10 students.
Microsoft Excel Reference Page
Syntax and Description of the CUBERANKEDMEMBER Excel Function
I would like to use the CUBERANKEDMEMBER function to create a time series calculation. However, I cannot find the syntax for this function in Excel. Can someone please provide the syntax for this function?
About CUBERANKEDMEMBER Excel Function
The CUBERANKEDMEMBER function returns the member in a cube at the specified rank.