Lookup the nth highest number in a row

[errigal]

Hi

Newbie question

If I have a row (or column for that matter) with 10 numbers in it and I want to extract the 4th highest for example to another cell, what function can I use to do this.?

Thanks in advance

[Ron Coderre]

Try the LARGE function.

example:
This formula returns the 3rd largest value in A1:A10

Please Login or Register  to view this content.

Is that something you can work with?

[errigal]

Yes thats perfect. Thank you