Get instant live Excel expert help to learn how to rank in Excel

“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'm assigning a different RAND number to a quantity of cells on one sheet. Those 'quantity of cells' contain text and some contain a pic. On a different sheet I randomly select a few of those 'quantity of cells' using - "=INDEX(WDM!$B$2:$B$13,RANK(WDM!A2,WDM!$A$2:$A$13))" It comes up with a different sub-set of 'quantity of cells' when it re-calculates - works perfect. Except the cells with pics won't display those pics. Got any ideas?
Solved by Z. H. in 21 mins
I'm in charge of an axe throwing league and I need a spreadsheet that ranks people on Wins and total points. Wins needs to be the bigger deciding factor so someone with 2 wins and 10 points would rank higher than someone with 1 win and 100 points.
Solved by X. H. in 28 mins
Hi, I am trying to rank cells in different columns that are not next to each other. I have tried the rank in the name box, but I have a big number of rankings to be done.
Solved by G. C. in 29 mins
I have a data set with numbers in columns B, C, and D. In columns F, G, and H i would like to display the results of combining the numbers in three different configurations from columns B, C and D. Example B C D F G H 8 0 6 80 86 06 F, G and H have shown all possible ways to pair the three numbers (in pairs) from columns B, C, and D I need that process to occur from rows 4 down to row 23 To get the results in F, G and H columns i used "=SMALL(B3:D3,2)&SMALL(B3:D3,3)", seems to work but as I copy down from row 4 to row 23. Then I need to to rank the frequency of results from F, G and H
Solved by F. Y. in 28 mins
I need to display the rank results of referenced cells and remove Value and N/A errors
Solved by X. F. in 21 mins
I have a spread sheet that has a few rows with duplicate numbers in them, I want the frequency and rank functions to ignore them.
Solved by I. J. in 27 mins
Solved by S. E. in 16 mins
how to use rank formula in excel 2013? I need formula to find the lowest rank for each name
Solved by T. A. in 11 mins
I would like help building a simple template, something that when data is entered it is represented in chart form. Bar charts, etc, that "rank" employees from # 1 seller to the worst seller. I can attach a sample data spreadsheet and further communicate details once a tutor / helper is assigned to me.
Solved by K. D. in 13 mins
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