Calculating Rank

[Bill Harrison]

I would like to calculate the rank of a cell in a group of cells.

ie - I have a number in each cell from b1:b10 In b12 I would like to
have the rank of the number in b1. Then in b13 I would like to have the
rank of the number in b2 and so on.

 

[immanuel]

In B12, try:

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

And drag down to B21.

/i.

 

[Peo Sjoblom]

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

copy down