Cube

CUBERANKEDMEMBER Function in Excel

Returns the nth member in a set.

Syntax

  • =CUBERANKEDMEMBER(connection, set_expression, rank, [caption])

Arguments

  • connection (required): Connection string to cube
  • set_expression (required): MDX set expression or CUBESET reference
  • rank (required): Position in set (1-based)
  • caption (optional): Display text

Examples

  • =CUBERANKEDMEMBER("Sales", A1, 1) - Get first member - Result: Member

CUBERANKEDMEMBER and data models

  • Validate members with CUBEMEMBER before CUBEVALUE.
  • Confirm the connection name matches your Power Pivot or OLAP model.
  • Explore summaries with [Pivot tables guide](/guides/excel-pivot-tables-guide/).

Common errors

  • #N/A if rank out of range

Use cases

  • Top N analysis
  • Ranking
  • Set navigation

Frequently asked questions

  • What is the CUBERANKEDMEMBER function in Excel? CUBERANKEDMEMBER returns the nth member in a set. The syntax is =CUBERANKEDMEMBER(connection, set_expression, rank, [caption]). Typical use cases include top N analysis, ranking, set navigation.
  • How do I use the CUBERANKEDMEMBER function? To use CUBERANKEDMEMBER, type =CUBERANKEDMEMBER( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.
  • Why is CUBERANKEDMEMBER not working in my Excel? Common issues with CUBERANKEDMEMBER include #N/A if rank out of range. Start by checking the syntax =CUBERANKEDMEMBER(connection, set_expression, rank, [caption]), then verify each referenced cell or range.

Editorial review

  • Reviewed by Excel.Directory Editorial Team. Updated May 2026.