Excel Office

Excel How Tos, Tutorials, Tips & Tricks, Shortcuts


CUBERANKEDMEMBER function: Description, Usage, Syntax, Examples and Explanation

What is CUBERANKEDMEMBER function in Excel? The CUBERANKEDMEMBER function is one of the Cube functions in Microsoft Excel which returns the nth, or ranked, member in a set.  It is used to return one or more elements in a set, such as the top sales performer or the top 10 students. Syntax of CUBERANKEDMEMBER function CUBERANKEDMEMBER(connection, set_expression, rank, ) The CUBERANKEDMEMBER function syntax has the following arguments: Connection:…