View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
39N 95W 39N 95W is offline
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-