Loading…
Loading…
RANK.EQ tells you where a number stands in a list: 1 is the largest by default, or the smallest when the third argument is 1. Ties share a rank. PERCENTILE (same as PERCENTILE.INC) returns the value below which a given share of the data falls, so PERCENTILE(range,0.9) is the 90th percentile.
Syntax
RANK.EQ(number, ref, [order]) · PERCENTILE(array, k)
Common mistakes
Read the lesson, then try it yourself in a live spreadsheet.