I have two arrays that I want to put in order from the greatest to the least. I want to do this through a function that returns another array back.
Here is the description of the function that I want to use
Private Function PutInOrder(arrTotals() As Integer, arrValues() As String, HowMany as Integer) As Variant
I want it order by the array arrTotals and the array that is return I want made up of the corressponding values from arrvalue. The indexes are the same, ie arrTotals(3) is the totals for arrValue(3) <- and this is what should be put into the final array. The HowMany is how large I want the array. So it will return say only the top 8 values.
Now a few requirements speed is not the overpowering issue, although somewhat important, the fewest possible resource is more important.