# 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