“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

I need to use rank function in excel but reference numbers are in two different ranges
what I need should be like this:
=RANK(A1,A1:A8&B9:B18)
(range from A1 to A8 and the continue of range is placed on B9:B18)

Solved by D. D. in 18 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 O. L. in 24 mins

BACKGROUND
§Homedepot.com is structured by Department (i.e. 27 = Lighting) which can have multiple Classes (i.e. 27L Class 1 = Light Bulbs)
§All items on homedepot.com have a unique Product ID
§Vendors can span multiple Departments or Classes
§Orange tabs in the attached include the raw data
§Please input answers into the Green tab
EXERCISE
§Rank the top departments by total sales
§For the top department, rank the vendors by total sales
§For the top department, calculate margin rate for each of the top 10 vendors

Solved by F. H. in 11 mins

I have monthly stock price data for 280 stocks for the past 8 years (96 months), I have another sheet with the monthly percentage increase of all the stocks over the same time frame. I need to rank the stocks each month from best performing to worst performing, then take the best performing 10% of stocks from the previous month and work out how they perform collectively for the next month. I need to do this 96 times and more for different amount of months and there must be a confusing quick way which an expert will know, can you help me out?

Solved by A. D. in 19 mins

I need a formula that rank using excel, will allow me to rank highest degree type obtained by students. some students have multiple (masters, bachelors), but this varies person by person. so the two fields i have are name and education degree type

Solved by I. W. in 20 mins

There are 4 Tiers in the league, with different points in each one. Every few weeks, there will be a “re-tier”, whereas a few teams on the top of each division will move up, while the bottom 4 will move down – hence the re-tier.
The “WED” tab is the one to work on. Goal is to cut and paste from the league website and to have the far right columns populate to show the playoff standings, finding/looking up the team names and sorting them by top rank with points.
Please format this as well. If you wanted to make it so the rows align, you can label the tiers in another fashion. Right now the boxes on the right are a bit off in alignment.

Solved by C. W. in 19 mins

I need help with excel rank formula without skipping numbers. I have to rank 280 numbers from smallest to largest in groups of %10, so the smallest 28 numbers are 1 and the largest are 10. I'm sure this is simple for an expert!

Solved by I. Q. in 23 mins

I have to use VLOOKUP for my assignment in class, and she gave me no explanation on how to do it (online class) and the book doesn't explain it. I don't know how it works or what to do... All the instructions say are "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"

Solved by F. Y. in 23 mins

Please help with rank excel formula with duplicates. A ranking formula I'm using does not rank a column of figures correctly if there are duplicate values. On the sheet labelled "Movers", column AE30 to AE44 is an example of the problem. The subsequent data being pulled via lookup in columns J30-44 and K30-44 then doesn't display correctly.

Solved by I. Y. in 24 mins

Can you help me to rank the data on my file?

Solved by K. A. in 28 mins