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