Thanks, Harlan. I just keep thinking that there must be some way to
integrate the two formulas. The problem seems to be that Microsoft has not
provided any standard functions for sorting and filtering arrays so they can
continue to be used in the same formula.

Thanks,
Blue

**************
"Harlan Grove" wrote in message
...
"Blue Max" wrote...
...
. . . isn't there a single formula that can both
sort and extract unique values at the same time? . . .
...

Almost. If the possibly duplicate values were in a range named D, that
range could contain numbers and text, and you want the distinct
numbers to appear before the distinct text in the results, try the
following array formulas.

E1 [1st distinct value]:
=IF(COUNT(D),MIN(D),INDEX(D,MATCH(0,COUNTIF(D,"<"& D))))

E2 [2nd distinct value]:
=IF(SUM(--(D<=E1))<COUNT(D),MIN(IF(DE1,D)),
INDEX(D,MATCH(IF(COUNT(E1),0,COUNTIF(D,"<="&E1)),
IF(ISTEXT(D),COUNTIF(D,"<"&D)),0)))

Fill E2 down to get the subsequent distinct values.

Note: for large range D, these formula will take a long time to
recalculate - there are pronounced benefits to using an intermediate
range for sorted values.