Urutkan suatu angka berdasarkan rentang angka
=RANK.EQ(number, ref, [order])| Parameter | Deskripsi |
|---|---|
number |
The number to rank. |
ref |
A range that contains the numbers to rank against. |
order |
[optional] Rank ascending or descending. Default is zero. |
The basic syntax for RANK.EQ looks like this:
=RANK.EQ(number,ref,[order])The RANK.EQ function has two modes of operation, descending and ascending, which are controlled by the order argument. To rank values where the larges
=RANK.EQ(A1,range) // rank descending (default)
=RANK.EQ(A1,range,0) // rank descendingTo rank values where the smallest value should be 1, set order to 1:
=RANK.EQ(A1,range,1) // rank ascendingIn the worksheet below, the goal is to rank test scores. For test scores, the highest score should be assigned a rank of 1, so the RANK.EQ function is
=RANK.EQ(C5,$C$5:$C$12)In the example below, the goal is to rank race times. This is an example of where we want to assign a rank of 1 to the fastest time, which will be the
=RANK.EQ(C5,$C$5:$C$12,1)