LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help With Code - Array and Range Sandy Excel Programming 8 September 2nd 05 01:09 AM
tips for organizing code for distribution Eric[_27_] Excel Programming 0 May 29th 05 10:11 PM
Can I use array to simplify this code. broogle Excel Programming 3 March 18th 05 12:57 PM
Code for Array formula Annette[_5_] Excel Programming 1 February 22nd 05 02:09 PM
Simplifying code using array John Pierce Excel Programming 3 December 15th 03 03:17 AM


All times are GMT +1. The time now is 12:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"