###### Asked in TechnologyAnna University

Technology

Anna University

# What is the use of rank list in engineering counseling?

**We need you to answer this question!**

###### If you know the answer to this question, please register to join our limited beta program and start the conversation right now!

## Related Questions

###### Asked in Microsoft Excel

### How do you rank marks that do not follow each other in Excel?

You can use the RANK function. Put all your numbers into a
column. They can be in any order. In the cell beside the first
number enter the RANK function. It specifies the cell you want to
rank, the list of values that it is being ranked out of, and
optionally whether you want to rank it in ascending or descending
order. Say your full list of values are in the cells from A2 to
A15. In cell B2 you could enter the following formula to find where
the value in A2 ranks overall:
=RANK(A2,A2:A15)
If, as is likely, you want to copy that down for all values, you
need to absolute the list of values, so the formula would be like
this:
=RANK(A2,$A$2:$A$15)
If use the order option and it is 0 (zero) or omitted, it ranks
the number as if it were a list in descending order. This is the
most common way of doing it. If order is any nonzero value, it is
treated as if it were a list sorted in ascending order. It is
omitted in the above example. If included you could have something
like:
=RANK(A2,$A$2:$A$15,1)

###### Asked in Math and Arithmetic

### How does engineering use math as a job?

Math (or maths) is not a job and so engineering does not use
math as a job!
Math (or maths) is not a job and so engineering does not use math
as a job!
Math (or maths) is not a job and so engineering does not use math
as a job!
Math (or maths) is not a job and so engineering does not use math
as a job!

###### Asked in Microsoft Excel

### How do you rank using Microsoft Excel?

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.