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-
|