Find

[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,

 

[Max]

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