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.