Get instant live expert help on percentile vs percentage

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

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I need sales percentage analysis for previous year vs. current year.
Solved by E. Y. in 21 mins
Is there a way to compare all rows to each other? I have a large 3000 row spreadsheet, and on one column, I would like to compare row 1 vs 2, 1 vs 3, 1 vs 4, 1 vs 5, 1 vs 6.....2999 vs 3000. I know, that's 5 million combinations. I will be dividing the smaller number into the larger number, to get a percentage/correlation.
Solved by O. Q. in 25 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
I need to create an excel spreadsheet. Here are the parameters: I have 5 games that can either win or lose. Team 1 Vs. Team 2 Team 3 Vs. Team 4 Team 5 Vs. Team 6 Team 7 Vs. Team 8 Team 9 Vs. Team 10 I need to visually see all the combinations of those games and again the only outcomes are win or lose.
Solved by A. L. in 11 mins
I need to calculate the achievement percentage for q1,q2,&q4. For example accuracy( would be gut / finish (ie how accurate their forecasts were every week vs. how they actually finished) and then *achievement* would be finish / target (how well they did to their EOQ goal
Solved by T. W. in 25 mins