Get instant live Excel expert help to learn how to rank in Excel

I'm assigning a different RAND number to a quantity of cells on one sheet. Those 'quantity of cells' contain text and some contain a pic. On a different sheet I randomly select a few of those 'quantity of cells' using - "=INDEX(WDM!$B$2:$B$13,RANK(WDM!A2,WDM!$A$2:$A$13))" It comes up with a different sub-set of 'quantity of cells' when it re-calculates - works perfect. Except the cells with pics won't display those pics. Got any ideas?

I'm in charge of an axe throwing league and I need a spreadsheet that ranks people on Wins and total points. Wins needs to be the bigger deciding factor so someone with 2 wins and 10 points would rank higher than someone with 1 win and 100 points.

Hi, I am trying to rank cells in different columns that are not next to each other. I have tried the rank in the name box, but I have a big number of rankings to be done.

I have a data set with numbers in columns B, C, and D. In columns F, G, and H i would like to display the results of combining the numbers in three different configurations from columns B, C and D. Example B C D F G H 8 0 6 80 86 06 F, G and H have shown all possible ways to pair the three numbers (in pairs) from columns B, C, and D I need that process to occur from rows 4 down to row 23 To get the results in F, G and H columns i used "=SMALL(B3:D3,2)&SMALL(B3:D3,3)", seems to work but as I copy down from row 4 to row 23. Then I need to to rank the frequency of results from F, G and H

I need to display the rank results of referenced cells and remove Value and N/A errors

I have a spread sheet that has a few rows with duplicate numbers in them, I want the frequency and rank functions to ignore them.

I NEED A RANK FORMULA IN EXCEL 2013 TO FIND THE LOWEST RANK FOR PARTICULAR NAME

how to use rank formula in excel 2013? I need formula to find the lowest rank for each name

I would like help building a simple template, something that when data is entered it is represented in chart form. Bar charts, etc, that "rank" employees from # 1 seller to the worst seller. I can attach a sample data spreadsheet and further communicate details once a tutor / helper is assigned to me.

how do you calculate percentile rank in excel when the question mean is known for 10 companies. Example the Mean is 3.58 from the sum of the 10 companies Mean divided by 10. The lowest Mean of the 10 organizations is 2.85 and the highest Mean is 4.22 Our goal is to be able to show the percentile rank of the 10 companies for their mean.