Wauvel

Excel like a finance pro.

← The library

Compatibility function

PERCENTRANK

Returns the percentage rank of a value in a data set; replaced by PERCENTRANK.INC.

Rarely usedDifficulty 1300 · ProficientUsage rank #356 of 520
Practice · 2 questions →

When to use it

The percentage rank of a value. Replaced by PERCENTRANK.INC.

The shape of it

Syntax
=PERCENTRANK(array, x, [significance])

Worked examples

  • A value in the set

    =PERCENTRANK({13,12,11,8,4,3,2,1,1,1},2) → 0.333

    Three of nine others below.

  • Simple

    =PERCENTRANK({1,2,3,4,5},4) → 0.75

    Three of four below.

  • Another

    =PERCENTRANK({13,12,11,8,4,3,2,1,1,1},4) → 0.555

    Another value.

Worth knowing

  • PERCENTRANK.INC is identical.
  • Default 3 significant digits.
  • Values outside the data return #N/A.

Where it goes wrong

  • #N/A when x is outside the data.
  • Flagged by the Compatibility Checker.

Related

FORECASTMODEPERCENTILEQUARTILERANKSTDEV

Learn the moves here — or let Wauvel run them on your numbers.

Meet your AI CFO →

One CFO-grade Excel tip a week

A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.