Excel Function : CUBERANKEDMEMBER

Download now!

Excel Function : CUBERANKEDMEMBER

Category

Cube

Description

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

https://support.office.com/en-us/article/CUBERANKEDMEMBER-function-07efecde-e669-4075-b4bf-6b40df2dc4b3

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.