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

If I wanted to rank a set of values in different cells, all in the same column or all in the row from lowest to highest, without sorting, how would I do that? . e.g. Cell A2=14.3, A3=5.6, A4=8.9, A5=11.3, and A6=2.4 How could I put a ranking in column B to show that Cell A6 ranked 1st, A3 2nd, etc...?
Solved by E. S. in 21 mins
I'm trying to run formulas to rank average excel times and rank them out accordingly, however, I obviously get an error when one of cells is empty as the times have not been called in yet. Can I write the formula to skip empty cells while still providing the data that I want?
Solved by B. F. in 15 mins
How to rank on excel? I want to rank each column by color who came in 1st, 2nd, 3rd, and last place.
Solved by G. H. in 12 mins
"To determine which clothing lines may sell well online, you decide to rank them on a scale from A to E. In cell H5, using a Vlookup function, determine the product line ranking of each product based on the Yearly Sales. Use the range name assigned to the lookup table."
Solved by M. H. in 11 mins
Enter a function in cell N3 that calculates the rank of store 251 based on the averages in the range M3:M5.
Solved by S. J. in 29 mins
Hi I have to rank my customers based on 2 different columns information. How do I do that. Column one is headcount numbers and the other column is a $ value. According to the info of those two I have to rank this list.
Solved by X. F. in 24 mins
I want to add rank formula excel in my pivot table. I used rank formulas in calculated field but it just #N/A. How to calculate ranking based on the value in pivot table?
Solved by E. W. in 19 mins
In cells I3:I10 I need to create an IF function to calculate the average numerical ratings for each employee. Only managers get evaluated by Leadership rank in column H. Column C indicates whether the employee is a manager. Thus, the average calculation should only include the values in column H if the employee is a manager. Even if a rating is given to a non-manager employee in column H, that number should not be included in the average in column I. How do I make this into a IF function?
Solved by D. D. in 30 mins
im creating a fantasy hockey model and trying to use excel rank if formula in Excel. If someone has played more than a certain number of games, and if they're certain position how to rank them accordingly
Solved by X. D. in 23 mins
I need to match two column, if one number in a column number falls in a range within the 2nd column. The result is on track or off track. Condition: (Column A: Age, ColumnB: Rank1-8) Under Age 30, Rank 1-2 ontrack Over Age 30, Rank 1-2 off track Between Age 31-37, Rank 3-8 On Track Between Age 38-45, Rank 5-8 On Track Above 45, Rank below Rank 8 Off Track
Solved by F. Q. in 15 mins