Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
sort numeric array
hi! I have an array with numbers. i want to sort the array based on the size
of the numers. how can i do this? do I need to write a function for it or does it exist in vba already? please help! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
sort numeric array
Arne,
One of these methods in VBA, depending on the number of elements: http://www.google.co.uk/search?hl=en...G=Search&meta= Or get Excel to do the sort for you: Dump the array on a WS, out of the way Sort on the WS Pick up the sorted values. NickHK "Arne Hegefors" wrote in message ... hi! I have an array with numbers. i want to sort the array based on the size of the numers. how can i do this? do I need to write a function for it or does it exist in vba already? please help! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
sort numeric array
here's an example, don't remember who posted it, though:
Sub sort_array() Dim arr As Variant Dim i As Long, j As Long, temp As Long 'sort the array arr = Array(2, 3, 4, 1, 6, 8, 7) For i = LBound(arr) To UBound(arr) - 1 For j = i + 1 To UBound(arr) If arr(i) arr(j) Then temp = arr(j) arr(j) = arr(i) arr(i) = temp End If Next j Next i MsgBox arr(0) End Sub -- Gary "Arne Hegefors" wrote in message ... hi! I have an array with numbers. i want to sort the array based on the size of the numers. how can i do this? do I need to write a function for it or does it exist in vba already? please help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Updating workbook with an alpha sort sheet and a numeric sort shee | Excel Discussion (Misc queries) | |||
can you sort numeric address numbers by even/odd | New Users to Excel | |||
Alpha Numeric Sort | Excel Discussion (Misc queries) | |||
Sort a numeric field | Excel Discussion (Misc queries) | |||
sort multi-dimensional array on numeric data? | Excel Programming |