removing a cell from an array

[Desperate]

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?

 

[Max]

let A2:A10 be my array
=LARGE(A2:A10,2)
will give you the 2nd largest. And so on.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000 Files:362 Subscribers:62
xdemechanik
---

 

[David Biddulph]

You need the LARGE function.