RANK Function
Returns the rank of a number within a list. Can rank in ascending or descending order. In Excel, RANK.EQ and RANK.AVG provide tie-handling options.
ExcelGoogle Sheets
Syntax
RANK(number, ref, [order])Parameter
| Parameter | Beschreibung |
|---|---|
| number | The value to rank. |
| ref | The range of values to rank against. |
| order(optional) | 0 or omitted for descending (largest = 1), 1 for ascending (smallest = 1). |
Beispiele
Rank a student's score (highest first)
=RANK(B2, $B$2:$B$50)Daten: B2 = 92 in a class of 50
Ergebnis: 3
Rank ascending (lowest = 1st place)
=RANK(B2, $B$2:$B$50, 1)Ergebnis: 48
Combined with TEXT for display
=RANK(B2, $B$2:$B$50) & " of " & COUNTA($B$2:$B$50)Ergebnis: 3 of 50
Tipps und Best Practices
- •In modern Excel, use RANK.EQ (same as RANK) or RANK.AVG (averages ties).
- •Lock the reference range with $ signs when copying the formula down.
- •To create unique ranks without ties, add a small tiebreaker: =RANK(B2,$B$2:$B$50)+COUNTIF($B$2:B2,B2)-1.
Verwandte Formeln
Brauchen Sie eine andere Formel?
Beschreiben Sie, was Sie brauchen, in einfachem Text und unsere KI generiert die Formel für Sie.
Formelgenerator ausprobieren