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-

Need help writing a filtering routine
 

Use a collection as shown in this code from John Walkenbach's site:

http://www.j-walk.com/ss/excel/tips/tip47.htm

--
Regards,
Tom Ogilvy




"39N 95W" wrote in message
...
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-