Well, either way it goes, he has a solution! Good of you to take the time to
work up the formulas for him.

I read it one way, then the other way, then back ... and of course after I
posted, I thought "what if I'm wrong?"

"paul" wrote:

thats how i read it <G
therefore in a cell at the bottom of your range(or at the top as long as the
whole range is selected) =countif(A1:A100,C1)/count(A1:A100) format as
percentage.
The reason i have a cell reference in the formula is so yu can type in 1 or
2 or 3 and the percentage shows,or of course have three seperate formulas
for each index
--
paul

remove nospam for email addy!



"JLatham" wrote:

If I've misinterpreted your problem, let me know. I'm thinking that perhaps
you want to calculate what percentage of the numbers with those indexes are
in comparison to the total number of all that are indexed?

"Dan" wrote:

Hi, I have a large series of numbers saved in one column
[34,5,21,98,34,3,432,55,27,90,1125,......]. These data are indexed, e.g. by
[1,1,1,1,1,1,2,2,2,2,2,2,2,2,2,......] which are in another column.

I need to calculate percentiles (25%,50% and 75%) of these numbers for
different indexes. In another word, I need to calculate percentiles for those
numbers with index of 1, 2, ... respectively, not the percentiles of all the
numbers.

Thanks a lot!