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 have four group that can be classified either high ,medium ,low and that the customer status should follow the high rank or medium or low of the group classification in case the customer is classified as high and the other three groups rank between high medium low result should be high if customer classified as medium used product high customer status change to high and if loww and used e three groups that classified as low status is low and if all are high status high if medium for all status medium can any one advice
Solved by B. W. in 25 mins
I need to place players 1st, 2nd, 3rd, etc. on a score sheet. 1 win = 2 points, Loss = 0 To break ties (Which are many) there is a shot differential (Shots For - Shots Against). There are 3 games w/ a total of 6 game points possible. The RANK does not work, because any team w/ 6 game points is automatically above anybody who lost a game (ie; 4 game points, and 2 game points to 0). Shot differential is added to the game points to determine placement of the ties. Unfortunately, several of the teams who lost games have total points w/ shot differential higher than the teams who lost no games (ie; 6 gam points). I'm going insane trying to figure this out...RANK is out of the question. Any suggestions?
Solved by M. Q. in 17 mins
I am trying to autonumber based on the cell to the right. However there are several lines with the rank "supervisors" that I do not want included in the auto numbering
Solved by V. L. in 22 mins
I am trying to autonumber based on the cell to the right. However there are several lines with the rank "supervisors" that I do not want included in the auto numbering. The code I used to auto number is given in the document I just don't know how to exclude certain cells.
Solved by M. A. in 21 mins
I'm wanting to create a table with a rank of my highest paying customers.
Solved by A. Q. in 16 mins
Having trouble with rank function on excel. Can you please tell me why the values in column Q are all returning a value of 1?
Solved by X. A. in 26 mins
I need help with ranking data in excel. I have sorted data in a pivot table to rank a list of people on production (highest to lowest). I wish to extract the phone numbers for those people in that order.
Solved by C. F. in 24 mins
You are a financial analyst for Williamston Widgets, Inc. The company’s 401(k) provider, the National Bank of Southeast Haslett, has been fired by your CEO for not providing adequate reports to plan participants. She has entrusted you with putting together a workbook with a dashboard that has the following features: 1. A table of all of the 401(k) plan’s available mutual funds, sorted by asset class and style category, that shows the following data points: Fund name, ticker symbol, style category, standard deviation, category rank for the past 1, 3 and 5 years, and expense ratio. 2. Create a Combo Box that contains each available fund, and displays the following data for the fund along with its category average: Fund name, ticket symbol, style category, performance for the past 1, 3 and 5 years, standard deviation, and expense ratio.
Solved by K. H. in 17 mins
We voted for personnel now I am attempting to find percent rank formula. Column B is worth 40%, Column C is worth 50%, Column D is worth 10% what formula do I use for each column and for the total column in E?
Solved by S. L. in 21 mins
Using a rank formula with drag to rest of column is expanding the parameters and not providing accurate information
Solved by G. H. in 23 mins