Which MS Excel function will return the rank of a value as a percentage of a given array or dataset?

Question

(array, x)

array = what range of data are you looking at?

x = Which value within the range are you looking at?

Answer 1

PERCENTRANK returns the rank of a value as a percentage of a given array or dataset.

=PERCENTRANK(array, x)

array - what range of data are you looking at?

x - which value within the range are you looking at?

Example:

If your values are in the array A2 through A19, and you want to know what percentage ranking the value of A15 is, you would type the function as follows: =PERCENTRANK($A$2:$A$19, A15).