ExcelBanter

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Find (https://www.excelbanter.com/excel-worksheet-functions/163419-find.html)

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,

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Tanya" wrote:
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,