Türk | İngilizce |
---|---|
RANK.EŞİT | RANK.EQ |
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