Alan,

Thank you very much for the suggestions and other resources.

***********************
"Alan Beban" wrote in message
...
Blue Max wrote:

Is there anyway, using a formula, to return an array of unique values
extracted from a larger array that has duplicate values. The resulting
array would be used for further calculations in the rest of the
formula?

Likewise, is there anyway to use the values (true, false) in one array
to determine which values are selected out of another array for
creating a resulting array to be used for further calculations in the
formula?

Can an array be sorted within a formula before using it in the balance
of the formula?

I am able to generate an array including all the values I need, but I
cannot get rid of the duplicate values in that array. Thank you for
any help.
If the functions in the freely downloadable file at
http://home.pacbell.net/beban are available to your workbook, you could
use something like the following to operate on a single column range:

Function SortedUniques(inputArray)
z = ArrayUniques(OneD(Application.Transpose(inputArray )), , "1horiz")
QuickSort z
SortedUniques = z
End Function

array entered into your output range.

Alan Beban