G Guest Apr 17, 2007 #1 hi! i have any array with numbers and i want to get the second biggest number in the array. how can i do this?
hi! i have any array with numbers and i want to get the second biggest number in the array. how can i do this?
N Norman Jones Apr 17, 2007 #2 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 '<<=============
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 '<<=============
