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: 14
Default Need help writing a filtering routine

Excel 2002
Windows XP Pro SP2

I have a one-dimensional array with ~90,000 numeric values stored in it.
There are, at most, only 4 or 5 different values among these 90,000. I need
to write a routine that will create a new array with just the unique
occurrences of the numeric values, AND I need to do this without using any
worksheet space (duh), AND I'd like to do it without having to sort the
original array.

The existing array variable is "aryMAIN() as Double"
(it is already populated)

The filtered array variable will be "aryFILT(100) as Double"
(100 just to be safe)

Any ideas on where/how to start?

All suggestions appreciated.

Go Bears!!


-gk-


 
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
trouble filtering a list. Why isn't column filtering? Pat Excel Worksheet Functions 1 July 18th 05 03:30 PM
Using (what goes in here) for sub routine Wally Steadman[_4_] Excel Programming 2 December 30th 04 06:51 PM
Filtering from multiples and writing to new page ric Excel Programming 5 April 16th 04 12:59 AM
SUB ROUTINE tokirk Excel Programming 1 January 19th 04 02:17 AM
Need VBA Routine John M. Lembo Excel Programming 0 July 13th 03 01:51 AM


All times are GMT +1. The time now is 05:04 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"