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

Diğer fonksiyonlar
Bağımsız değişkenler listesinde kaç tane değer bulunduğunu sayar
Bağımsız değişkenler listesinde kaç tane sayı bulunduğunu sayar
Aralıktaki boş hücre sayısını hesaplar
Verilen birden çok ölçüte uyan bir aralık içindeki boş olmayan hücreleri sayar
Verilen ölçütlere uyan bir aralık içindeki boş olmayan hücreleri sayar
İki veri kümesi arasındaki bağlantı katsayısını verir
Doğrusal eğilim boyunca bir değer verir