Get instant live expert help on I need help with percent vs percentile

“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 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
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
Calculate percent totals for verticals from Q1'17 1/16 -Q1'18 3/26 gut vs actuals. Final actuals can be found here :Q1’18 Quotas Look at “prelim actuals” Q4’17: Quotas Look at “prelim actuals” Q3’17: Quotas “Prelim Actuals” Q2’17: “Final Actuals” Q1’17: Quotas Use “Final Q1” Please let me know which vertical actuals is within 5%
Solved by D. L. in 15 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'm calculating percent complete and percent remaining in excel. How would I do that?
Solved by Z. Y. in 17 mins