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
In cells I3:I10, create an IF function to calculate the average numerical ratings for each employee. Only managers get evaluated by the 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.
Solved by E. E. in 22 mins
I want to be able to rank several columns simultaneously within and a worksheet
Solved by K. W. in 18 mins
Need some help with vlookup and excel rank function in the "Raw" sheet.
Solved by D. D. in 26 mins
I am trying to discover the best way to accurately rank my employees based on the 4 categories on the worksheet
Solved by V. J. in 20 mins
I need help creating a spreadsheet that can rank my associates in order of performance. For example, I need to assign specific categories a specific point value and then rank associates based on overall points.
Solved by Z. Q. in 13 mins
Assign the named range of Rank to the cells M4:N8.
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. Copy the formula through H16. In cell H21, 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. Copy the formula through H32.
Solved by C. C. in 27 mins
Use excel rank.avg function in cell N3 to calculate the rank of store 251 based on the averages in the range M3:M5.
Solved by Z. U. in 28 mins
Would like to create a top 10 out of a list of data, column A being name and Column B what rank, whats best way to do this
Solved by B. B. in 25 mins
Hello, I have duplicate datas and I want to rank them. I do not want to remove the duplicates. The data I have is like the in the columns A and B. But I want to have them as in E and F. I want to indicate their ranking based on how many of them are there. For example if there are three A's and two B's, I want them to be:
name freq.
A 1
A 2
A 3
B 1
B 2
Is there an easy way for this? I have to do this for thousands of data. Thank you in advance.
Solved by V. J. in 19 mins
I need help with rank excel 2016 to rank my data based on a different criteria
Solved by F. J. in 24 mins