"Teethless mama" wrote...
Try this:

=IF(ISERR(SMALL(IF(MATCH(names,names,0)=ROW(INDIR ECT("1:"&ROWS(names))),
ROW(INDIRECT("1:"&ROWS(names)))),ROWS($1:1))),"", INDEX(names,
SMALL(IF(MATCH(names,names,0)=ROW(INDIRECT("1:"&R OWS(names))),
ROW(INDIRECT("1:"&ROWS(names)))),ROWS($1:1))))
....

Or use shorter, more efficient formulas.

B1:
=T(A1:A100)

B2 [array formula]:
=IF(OR(COUNTIF(B$1:B1,A$1:A$100)=0),
INDEX(A$1:A$100,MATCH(0,COUNTIF(B$1:B1,A$1:A$100), 0)),"")

Fill B2 down as far as needed.