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

any ideas?


---
Message posted from http://www.ExcelForum.com/

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?
-----Original Message-----
i am trying to find a way to combine formulas to look up
the second
largest entry in a list.

any ideas?


---
Message posted from http://www.ExcelForum.com/

.

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

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

any ideas?


---
Message posted from http://www.ExcelForum.com/