Find

T

Tanya

In an Excel 2003 worksheet I have a list of test scores and I'm trying
to determine which percentile each score falls into. I don't think the
Percentile function will return the information I'm looking for; as I
understand it, that function indicates the values that fall in the
percentile as defined in the Kth argument. Anyone have a suggestion?
Tthanks,
 
G

Guest

Think PERCENTRANK will achieve what you're after

Assuming test scores in A2:A20
In B2: =PERCENTRANK(A$2:A$20,A2)
Format B2 as percentage, copy down
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

logical functions utilizing percentiles 7
Find A Value's percentile 3
Percentile 2
Is there a better way of doing this? 4
Calculating Percentiles of Test Scores? 4
Remvoving Null Items from an ADO Recordset prior to sending to Exc 3
Percentile Function 3
User Defined Functions 1

Top