Given how ranking works.., same score share the same rank. So...

90 1
60 2
32 3
30 4
30 4
28 5
28 5
28 5
26 6
26 6
26 6
26 6
26 6
26 6

...is how the results should display.

If the top score is the marker for percentile then set the NumberFormat
for colC to Percent and enter the following formula in C3...

=$A3/$A$1

...and copy down. The results are...

90 1 100%
60 2 67%
32 3 36%
30 4 33%
30 4 33%
28 5 31%
28 5 31%
28 5 31%
26 6 29%
26 6 29%
26 6 29%
26 6 29%
26 6 29%
26 6 29%

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion