Definition and Usage of the RANK.EQ Function

The RANK.EQ function is utilized to determine the rank of a specific value within a data set. It operates identically in both Excel and Google Sheets. This function returns the rank of a given number within an array of numbers, sorted in descending order by default.

Syntax and Parameters

 RANK.EQ(number, ref, [order]) 

• number: The number whose rank you want to find.
• ref: The array of numbers against which the ranking will be determined.
• order: Optional. If set to 0 or omitted (default), the ranking is done in descending order; if 1, the ranking is done in ascending order.

Example Usage

Let”s consider the case of student exam scores to determine each student”s rank within the class:

 A B 1 Student Score 2 Ali 85 3 Ayşe 90 4 Mehmet 88 5 Zeynep 75 

The following formula gives the rank of the student in cell B2:

 =RANK.EQ(B2, B2:B5) 

This formula ranks Ali within the class in descending order of scores, yielding a rank of 2 (second highest after Ayşe).

Practical Applications and Solutions

Ranking Employees by Annual Sales in a Company

Consider a scenario where you need to rank employees based on their annual sales figures:

 A B 1 Name Sales 2 Elif 150000 3 Can 250000 4 Seda 185000 5 Emre 220000 

To rank these sales figures in descending order, use the following formula:

 =RANK.EQ(B2, B2:B5) 

This will rank Elif”s sales among the employees and give a result of 4.

Ranking Students by Academic Performance in a School

At a school, ranking students based on academic performance might be necessary. Given their grades:

 A B 1 Student Grade 2 Lale 92 3 Onur 87 4 Esra 90 5 Burak 85 

To rank the students in ascending order of their grades, use the following formula:

 =RANK.EQ(B2, B2:B5, 1) 

This formula determines Lale”s rank within the class, resulting in a rank of 1, as she has the highest score.

Daha fazla bilgi: https://support.microsoft.com/tr-tr/office/rank-eşİt-işlevi-284858ce-8ef6-450e-b662-26245be04a40