RankKind.Type specifies the type of ranking.
Enumeration Options
Enumerations simplify the process of selecting options within a function. To specify the RankKind.Type, users have the option to either input the below Argument description (which provides more information) or the shorter Value (which provides a more concise representation).
| Argument | Value | Description |
|---|---|---|
| RankKind.Competition | 0 | Identical items receive the same rank. In case of identical items there is a gap before the next rank. This approach may generate non-sequential rankings, with the possibility of repeated rank numbers. |
| RankKind.Dense | 1 | Identical items receive the same rank and the next ranking item is numbered consecutively without gap. Method guarantees a ranking with consecutive numbers where a rank can appear multiple times. |
| RankKind.Ordinal | 2 | Every item, even those that are identical, gets a unique rank. Duplicate values get consecutive rankings. |
Applies to
Here’s a list of functions that work with RankKind.Type:
2023-2024 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy