CUBERANKEDMEMBER function - Microsoft Support
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 the top 10 students.
Guidelines and examples of array formulas - Microsoft Support
Sum every Nth value in a range of values. The following examples show you how to create multi-cell and single-cell array formulas. Where possible, we’ve included examples with some of the dynamic array …
UNIQUE function - Microsoft Support
Learn about the UNIQUE function, which returns a list of unique values in a list or range. UNIQUE is in a class of functions called dynamic arrays.
Cube functions (reference) - Microsoft Support
Use to validate that a member name exists within the cube and to return the specified property for this member. Returns the nth, or ranked, member in a set. Use to return one or more elements in a set, …
Excel functions (alphabetical) - Microsoft Support
Use to validate that a member name exists within the cube and to return the specified property for this member. Cube: Returns the nth, or ranked, member in a set. Use to return one or more elements in …
Using the CALL and REGISTER functions - Microsoft Support
The nth argument must be a pass-by-reference data type (C, D, E, F, G, K, L, M, N, O, P, or R). The DLL function or code resource must also be declared with the void keyword in the C language (or the …
TEXTAFTER function - Microsoft Support
When searching with an empty delimiter value, TEXTAFTER matches immediately. It returns the entire text when searching from the front (if instance_num is positive) and empty text when searching from …
PERCENTILE function - Microsoft Support
Returns the k-th percentile of values in a range. You can use this function to establish a threshold of acceptance. For example, you can decide to examine candidates who score above the 90th …
Use the COUNTIF function in Microsoft Excel
Use COUNTIF, one of the statistical functions, to count the number of cells that meet a criterion; for example, to count the number of times a particular city appears in a customer list. In its simplest …
Look up values with VLOOKUP, INDEX, or MATCH - Microsoft Support
Using an approximate match, searches for the value 1 in column A, finds the largest value less than or equal to 1 in column A, which is 0.946, and then returns the value from column C in the same row.
VLOOKUP function - Microsoft Support
Learn how to use function VLOOKUP in Excel to find data in a table or range by row. Our step-by-step guide makes vlookup in excel easy and efficient.