PERCENTRANK function help...

  • Thread starter Thread starter Derrich R
  • Start date Start date
D

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?
 
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
 
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.
 
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.
 
Back
Top