Ranking a column of data

[dcbeagle]

I have a set of results (educational assessment) and I would like the next column to rank the values. Is this easy to do?

 

[CodeNinja]

Use the Rank function....[TABLE="class: grid, width: 50"]
<tbody>[TR]
[TD]Row[/TD]
[TD]Value[/TD]
[TD]Rank[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]7[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]9[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]13[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]56
[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]5[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]63[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]44[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]51[/TD]
[TD]7[/TD]
[/TR]
</tbody>[/TABLE]

Cell B1 would be: =RANK.AVG(A1,$A$1:$A$9,1)

First item is the number you want to rank, second item is the range you want to rank, third is ascending or descending ranking.

 

[Snakehips]

dcbeagle,

Welcome to MrExcel.

See if the standard RANK function suits your needs.

 

[dcbeagle]

Brilliant solution. Very clear with your explanation. Thank you.

 

[dcbeagle]

Most impressed. Thank you.