If you do not have duplicate values, "Large" formula will be useful.

Try it like; =Large(A:A,2)

The number at the end of it represents position of highest number you
desire, so for third-highest you can put formula as =Large(A:A,3).

--
Regards,
Pritesh


"MimiS" wrote:

You could set up a column next to your figures and use =rank.