Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Biggest Loser Formula | Excel Discussion (Misc queries) | |||
Finding a name with biggest number | Excel Worksheet Functions | |||
Would u help me with a Biggest Movers type of comparison? | Excel Discussion (Misc queries) | |||
Biggest commercial .xla file? | Excel Programming | |||
Determining biggest variable | Excel Programming |