You need the LARGE function.
--
David Biddulph

"Desperate" wrote in message
...
Hello,

I am trying to make a formula that will find the largest and second
largest
numbers from an array. The largest is easy as it can be done with the max
function. The second largest is not so easy. Is there any way to subtract
a
cell from an array, I have tried the following two variations to no avail.

let A2:A10 be my array
let A12 be =max(A2:A10-max(A2:A10))
and then =max(A2:A10-index(A2:A10,Match(A12,A2:A10,1)))

any ideas?