CUBERANKEDMEMBER Function in Excel: Syntax, Examples and Free Practice
CUBERANKEDMEMBER is an Excel Cube function. Returns the nth ranked member from a cube set.
CUBERANKEDMEMBER syntax
Arguments
connection: The name of the data connection to the cubeset_expression: A text expression defining a set of cube membersrank: Which ranked position to returncaption: The display text to use instead of the raw name (optional)
When to use CUBERANKEDMEMBER
Used only when a workbook is connected to an external OLAP data cube (e.g. via SQL Server Analysis Services) — not relevant for typical spreadsheet work.
Practice CUBERANKEDMEMBER online, free
Open the live Excel-style spreadsheet and try CUBERANKEDMEMBER yourself. No Excel install or sign-up needed to start.
Practice CUBERANKEDMEMBER now →More Cube functions
Frequently asked questions
What does the CUBERANKEDMEMBER function do in Excel?
Returns the nth ranked member from a cube set.
What is the syntax of CUBERANKEDMEMBER in Excel?
The syntax is =CUBERANKEDMEMBER(connection, set_expression, rank, [caption]). connection: The name of the data connection to the cube; set_expression: A text expression defining a set of cube members; rank: Which ranked position to return; caption: The display text to use instead of the raw name (optional).
Where can I practice CUBERANKEDMEMBER online for free?
Open the free live spreadsheet on Cellgrids and try CUBERANKEDMEMBER yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Cube functions · Excel case studies · Excel tutorials · Excel shortcuts