Ranking 1st - 10th place

  • Thread starter Thread starter cassy01
  • Start date Start date
C

cassy01

i want to know if there is anyway that i can put a number next to m
column that works out each time the average changes.

for example:

i have the name in one column
the average in the next
then i want a number in the next that says what place he/she is.

John 5.7 3rd
Emma 6.3 2nd
Mark 9.2 1st
Sarah 1.4 4th

is this possible ??

Many Thanks
Ben
 
Hi Benn
if you values are stored in column B enter the following in C1
=RANK(B1,$B$1:$B$10)
and copy this formula down
 
Cassy

There is a rank formula but is expects that the list is
sorted in ascending (or descending) order.
The following formula in column H references the average
in column G and finds its rank from the range G2 to G11.

=RANK(G2,$G$2:$G$11)

The list is sorted in descending order

Regards
Peter
 
Hi Peter
the function does not require a sorted range. Works fine with an
unsorted range as well :-)
 
Hi Cassy,

In case you would want the smallest unit to be first and the largest to be
last, use this:

=RANK(B1,$B$1:$B$10,1)

HTH
Regards,
Howard
 
Back
Top