second biggest in array
 

hi! i have any array with numbers and i want to get the second biggest number
in the array. how can i do this?

second biggest in array
 

Hi Arne,

Try something like:

'=============
Public Sub Tester()
Dim arr As Variant
Dim Res As Double

arr = Range("A1:A100").Value

Res = Application.Large(arr, 2)
MsgBox Res
End Sub
'<<=============


---
Regards,
Norman


"Arne Hegefors" wrote in message
...
hi! i have any array with numbers and i want to get the second biggest
number
in the array. how can i do this?