RANK.EQ
The RANK.EQ function assigns a rank to a specified value within a list of values, with equal values receiving the same rank. It is used to determine the relative position of a value compared to others in a dataset.
Syntax 🔗
=RANK.EQ(number, ref, [order])
number | The value for which you want to determine the rank. |
ref | The range of cells or array containing the list of values to rank. |
order (Optional) | Specifies how to rank the number. 0 or omitted for descending order, 1 for ascending order. |
About RANK.EQ 🔗
Use the RANK.EQ function in Excel to determine a value's position relative to other values in a dataset. This function helps you assign ranks, which can be useful for identifying top performers or outliers. It's applicable for analyzing various data types, such as sales figures or test scores. By default, if there are ties (equal values), they receive the same rank, ensuring consistency in your results. You can also customize the ranking order to either ascending or descending, providing flexibility in your analysis.
Examples 🔗
If you have a list of test scores in cells A1 to A10 and you want to rank a specific score in cell B1 within this range, use the following formulas:
To rank in descending order, enter =RANK.EQ(B1, A1:A10, 0).
To rank in ascending order, enter =RANK.EQ(B1, A1:A10, 1).
Notes 🔗
Make sure the range in the ref argument includes valid numerical values. The RANK.EQ function ranks numbers based on their order in the reference array or range. If there are ties, the function assigns the same rank to the tied values.
Questions 🔗
The RANK.EQ function assigns the same rank to tied values within the dataset. For example, if two numbers are tied for the second position, they would both receive a rank of 2.
Can I specify the ranking order with the RANK.EQ function?Yes, you can specify the ranking order by using the optional order argument. Setting the order to 0 or omitting it ranks the numbers in descending order, while selecting 1 ranks them in ascending order.
No, the RANK.EQ function is not case-sensitive. It ranks the numbers based on their numerical value, regardless of the case in which they are presented.