vlookup problem

[ROBERTO]

i am trying to find a way to combine formulas to look up the second
largest entry in a list.

any ideas?

 

[Jase]

I am sure there is a better way than this, but you could
write a self defined function to do this then use it in
your sheet to give you the answer (remember to use the
whole list area as a call function or the macro won't
always update)

Just as a afterthought carn't you just order the list?

 

[Doug Glancy]

Roberto,

Can you just use the Large worksheet function, e.g.:

=LARGE(A1:A10,2)

which finds the second largest number in a list in A1:A10?

or in VBA

Sub test()
Dim v As Long
v = Application.Large(Range("A1:A10"), 2)
MsgBox v
End Sub

hth,

Doug