“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

how do you calculate percentile rank in excel when the question mean is known for 10 companies. Example the Mean is 3.58 from the sum of the 10 companies Mean divided by 10. The lowest Mean of the 10 organizations is 2.85 and the highest Mean is 4.22
Our goal is to be able to show the percentile rank of the 10 companies for their mean.

Solved by X. W. in 27 mins

I need a formula that ranks the highest number in the 1st percentile and the lowest number at the 100th percentile.

Solved by T. D. in 25 mins

My rank formula in excel is not working =IFERROR(RANK(C4,C24:H24,0),"") please help

Solved by K. J. in 20 mins

I need to match two column, if one number in a column number falls in a range within the 2nd column. The result is on track or off track.
Condition: (Column A: Age, ColumnB: Rank1-8)
Under Age 30, Rank 1-2 ontrack
Over Age 30, Rank 1-2 off track
Between Age 31-37, Rank 3-8 On Track
Between Age 38-45, Rank 5-8 On Track
Above 45, Rank below Rank 8 Off Track

Solved by F. Q. in 15 mins

I need a formula to find what the average transfer % is for the 0.25% percentile of a population using certain criteria.

Solved by S. S. in 18 mins