PERCENTRANK function help...

[Derrich R]

I already posted this, but allow me to reword my question
and include more detail:

Column A contains a score (not in numeric order)
Column B contains a rank (not in numeric order)
Column C should contain the Percentile
Cell D1 = 139
There are 139 rows.

A B C
456 4 =percentrank(array,number)
345 3
100 1
601 5
211 2
... ..
... ..
832 6

Now, for the function above I'm currently using:
=percentrank(B1:B139,D1). My result is "#N/A". I've also
tried using A1:A139 as my array...still nothing. Any
ideas?

 

[Paul Corrado]

Derrich,

Its not clear why you are using the number of rows as the reference. If you
are ranking the items in column A, then the first row in column C would have
the formula

=PERCENTRANK(A$1:A$139,A1)

and copy down through row 139

HTH

PC

 

[Norman Harker]

Hi Derrich!

I think that you are getting confused between PERCENTILE and
PERCENTRANK functions.

Try a look at Help:

PERCENTILE
Returns the k-th percentile of values in a range. You can use this
function to establish a threshold of acceptance. For example, you can
decide to examine candidates who score above the 90th percentile.

PERCENTRANK
Returns the rank of a value in a data set as a percentage of the data
set. This function can be used to evaluate the relative standing of a
value within a data set. For example, you can use PERCENTRANK to
evaluate the standing of an aptitude test score among all scores for
the test.



--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Public Holidays Monday: Central African Republic (National Day of
Prayer); El Salvador (Balance Day); Guatemala (Army Day); Israel (Rosh
Hodesh Tammuz); Sudan (National Salvation Revolution Day); Ukraine
(Constitution Day); Zaire (Independence Day).
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Derrich R]

You are absolutely correct. I understand the logic behind
the function. I was using that as a reference because it
was the last resort.

After trying over and over, I finally got the function to
work. As with one of my past issues, I forgot to reformat
the cell to %. *smack* I thought I learned my lesson the
first time.

The function works correctly now. Thanks for your
response.