View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] sarjuhindocha@gmail.com is offline
external usenet poster
 
Posts: 3
Default code for organizing array

Hi,

I am trying to organize an array that I have in VBA. Basically I have a
list that looks something like:

January 15
February 20
March 40
April 10

(the actual list has more columns and different type of data but the
idea is the same). What I would like is to have some code that can go
through the array and the producing a new array listing the 3 highest
values out of the 4. So the end result would look like:

April 10
January 15
February 20

Can anybody give me some help of how that code would look like? Also if
you can point me to how to find the answers to those kind of queries in
the future? I thought that posting it would be the best way but maybe
the answers are already present somewhere and I am just wasting
people's time (I have already bought some vba books but could not find
an answer in there). Thanks a lot!

rgds, Sergio