answersLogoWhite

0

You can use the RANK function to find the rank of a number amongst other numbers. To find the rank of the value in cell C5 amongst the cells from C2 to C30, you would do it like this:

=RANK(C5,C2:C30)
You can use the rank function. If you wanted to find what rank a value in cell B5 was in a range of cell was in cells B2 to B27, the function would be done like this:

=RANK(B5,B2:B27)

This will rank things in descending order. To rank in ascending order you would add an extra argument to the function. If it is not zero, it will do it in descending order.

=RANK(B5,B2:B27,1)
To show a rank for each number in a column, you use the rank function. If you have a list of numbers from cell A2 to A20 and you want to show the rank for each one beside it in column B, then you would start with this formula in B2 and copy it down:

=RANK(A2,A$2:A$20)
You use the RANK function. It will tell you the place of a value in a range. So say you have a range of values in cells A2 to A20. In cell B2 you could enter the following formula:

=RANK(A2,A$2:A$20)

Then copy the formula down to B20. The numbers in column B will be the ranking position of the corresponding figures in column A.

User Avatar

Wiki User

11y ago

What else can I help you with?

Related Questions

Can a person complete calculations in Microsoft Excel 2003?

Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.


Need help using Microsoft Excel 2010?

To do what?


Who are the creators of Microsoft Excel?

Microsoft excel was created by Microsoft


What are possible limitations using macros within Microsof Excel?

What are possible limitations using macros within Microsoft® Excel


How do you launch Microsoft Excel?

Programs->Microsoft Office->Microsoft Excel


Can you create an isometric grid using Microsoft Office Excel and how?

yes


How can data be printed on a page using a printer?

Microsoft excel then print it


What is the spreadsheet program in Microsoft office 2007?

I believe the only Microsoft program used to create spreadsheets is Microsoft Excel.


Who created Microsoft Excel?

Microsoft Excel was created by Microsoft Corporation. It was first released in 1985.


Is there any hidden game in Excel 2003?

There are no hidden games in Microsoft Excel after Microsoft Excel 2000, so there are none in Microsoft Excel 2003.


Advantage of using graphs in Microsoft Excel?

It is easy to understand the table details


How do you convert 120 kilo to pounds using Microsoft Excel?

=(120*0.45359237)