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.

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

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

"gb_S49" skrev i en meddelelse
...
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.

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

Supurb
Thank you to you both

"Ola" wrote:

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

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

gb_S49 wrote:
Supurb
Thank you to you both

"Ola" wrote:


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