"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?
....

The best approach depends on the final result you want. In general,
for all the things you seem to want to do, you should consider
downloading and installing Laurent Longre's MOREFUNC.XLL add-in,
avaialble from

http://xcell05.free.fr/morefunc/english/index.htm

Read its help file about its UNIQUEVALUES, HSORT, VSORT and
ARRAY.FILTER functions.