# 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 am trying to make a graph comparing two types of data (heart rate and difficulty rank) for two different subjects versus time. No idea where to start.
Solved by V. A. in 19 mins
I have a large spreadsheet with 40,000 contacts of companies. The companies range in contact count from 5 contacts to over 5,000. I need to rank them by contact count and group them by company. Can you assist?
Solved by E. W. in 22 mins
I need to take two spreadsheets and create a Pivot Table to aggregate contacts by company name, have a second column that shows a total number of contacts for each company, then be able to rank them from largest to smallest. Can you help me with rank function in table?
Solved by A. H. in 14 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 T. B. in 28 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. 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 Z. Y. in 26 mins
In cell I5, using logical functions, determine whether the product will be an online product. The product will be an online product if it has a ranking of A or B. Set the formula to return a value of Yes if rank was met and a value of No if rank was not met. Copy the formula through I16. Repeat the same formula for the men’s clothing lines starting in cell I21, and copy the formula through I32.
Solved by X. D. in 20 mins
I have a large spreadsheet where I need to remove unneeded rows that have the same values and descriptions that repeat throughout the large spreadsheet. I need these rows removed so that I can create formulas to sort and rank the real estate agents by production levels
Solved by E. W. in 23 mins
HI, I need to verify that a formula I was given is going to work correctly. I have a 200K row spreadsheet and the results are not producing what I expect. In a small file that was used to test the formula, it appears to work. The formula is =SUMPRODUCT((\$A:\$A=A2)*(B2>\$B:\$B))+1 I need to take value in A, compare it to value in B, and then in the next column, rank the items in B numerically. However, the values in column A and B frequently change. So there may be results 1, 2, 3 or 1,4,5,3,2 (I will need to sort to get the results in numeric order). I do know sumproduct is an extremely resource intensive formula.. Thank you.
Solved by K. D. in 18 mins
I've got an Excel spreadsheet that has two sheets in it that will be the EXAMPLE called Orange County Agent County Final. Inside this document, the Sheet named Data has all Real Estate Agent information. I need a 2nd PIVOT TABLE Sheet named PIVOT that will AGGREGATE the AGENTS by COMPANY NAME. NEW COLUMN will be ADDED totaling out the number of AGENTS per COMPANY so that I can rank them from MOST to LEAST. Inside each COMPANY, when you click you should see ALL AGENTS AND ALL THEIR CONTACT DATA including NAME, COMPANY, ADDRESS, PHONE, EMAIL. EXAMPLE sheet was done by your company. They should be ranked from largest to smallest.
Solved by F. C. in 28 mins
i have a filter page I am working on and I wanted to get a rank that showed the count of data on my filter page.
Solved by A. H. in 19 mins