Ranking?

S

Saxman

If I had a column of numbers starting in cells A1:A12, such as those
below, could I rank them in another column 1,2,3?
496
471
455
451
530
524
446
422
480
385
414
342
 
B

Bob Phillips

=RANK(A1,$A$1:$A$10)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
R

RagDyeR

Or, for the inverse ranking:

=RANK(A1,$A$1:$A$10,1)

--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

=RANK(A1,$A$1:$A$10)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top