second biggest in array

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 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
'<<=============
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vba array logic 3
Finding the maximum in an array of strings (Excel VBA) 6
How to read Excel Array to vb.net Arrays? 20
Arrays question 1
Shape Arrays VBA 0
Array to Multiple Arrays 3
Baffled with assignment of range to array why won't it work??? Anyhelp appreciated 4
Dynamic Creation of Arrays - Sorting into Bins problem 2

Back
Top