Return highest 4 values (MAX?)

Hi all,

I've got a matrix of data which contains various currency values users are enterring. I get this data from Sharepoint using an external query, so it can change when I refresh my dataset.

What I want to do is return the highest 4 values. I can use MAX (=MAX(C2:F13)) to return the highest value, but can't think of how I'll get the top 4. Seeing as the 4 highest values can be in any column, I can't check the MAX of each column (what if the highest 2 are both in C?) and compare.

Any thoughts on how I might acheive this?

Thanks for your help,
Bob

Take a look at the LARGE() function.
=LARGE(C2:F13,1) to get the max
=LARGE(C2:F13,2) to get the second etc...

Perfect, thanks for that!

I'd have thought they might put that as a "See Also" in the help function for MAX.