Order ranking. Any suggestions?

[Guest]

I want to rank / rate the top 20 cells contents in order. ie if i use
(=max(A:A)it will give me the maximum (highest) value. likewise unsing min.
Is there a way I could find the second highest, then third value etc.

 

[Leo Heuser]

Have a look at the RANK(), SMALL() and
LARGE() functions.

 

[Guest]

Have a look at the LARGE(A1:A100,B1) function. B1=1,2, ... 20
Ola Sandstrom

 

[Guest]

Supurb
Thank you to you both

 

[Aladin Akyurek]

If you also need to construct a list of items that is associated with
Top 20 values, you need something different:

http://tinyurl.com/44ywo