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!”
Here are some problems that our users have asked and received explanations on
Need rank function table help!
Set up a table based on my ranking/scoring system. want to rank a large data set based off of my logic
Solved by E. D. in 12 mins
I need a formula to return the excel rank the top 3 results using multiple (IF/Then critieria
Solved by M. U. in 19 mins
How to do ranking in excel? I have a data table where multiple rows have the same ID (e.g. 0001) and yet each row has a rank and a score.
For example
0001 rank1 score5
0001 rank2 score3
0001 rank3 score8
0002 rank1 score7
0002 rank2 score1
...
What is the formula required to sum all scores for each row where ID is 0001 and place the number next to 'rank1'?
Solved by E. H. in 16 mins
I have a list of students from several schools and there results. I can easily rank their results But... I can only allocate a position to the top two student in any given school. One school might have the top 5 results, but I can only give then two allocated spots in the top ten. Then I need the number six (top result) to show up as position 3 (assuming that they are not already filling two allotted spots.
I hope this makes sense. Thanks
Solved by V. W. in 25 mins
Hi, I need help with how to find percentile rank
Solved by T. J. in 14 mins
Need help with percentage rank excel. I have a formula that is finding rank even when filtered. Now I need to turn that rank into a percentage, 1-100, even when filter also. The formula for the rank is =SUM(IF(SUBTOTAL(103,OFFSET($R$2:$R$1022,ROW($R$2:$R$1022)-ROW($R$2),0,1))>0,IF(R2>$R$2:$R$1022,1)))+1
Solved by E. J. in 24 mins
how to rank data in excel? i have 2 columns that contain data I have ranked independently,i then did the average of the two rankings in a third column. In the forth column i am trying to rank that result from the third but get an eeror message?
Solved by E. Q. in 13 mins
I need a formula that will apply numbers (in this case points) based on the ranked positions. i.e. rank number 1 will get 32 points, number 2 31 points and so on until number 32 will get 1 point.
Solved by A. Q. in 22 mins
I would like to rank excel variable blocks of cells within the same column
Solved by C. W. in 21 mins
I need to find how i can rank data from a table that i have generated from survey question.
Solved by O. S. in 17 mins