Look for all new names in a list

If you still would like a formula try array-entering this in B3 and filling down until you get blanks.

Formula:

=IFERROR(INDEX($A$3:$A$25,SMALL(IF(FREQUENCY(MATCH($A$3:$A$25,$A$3:$A$25,0),ROW($A$3:$A$25)-MIN(ROW($A$3:$A$25))+1),ROW($A$3:$A$25)-MIN(ROW($A$3:$A$25))+1),ROWS($1:1))),"")

If you aren’t familiar with array-entered formulas array enter means the formula must be committed by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.

But if it's doable GCExcel's approach is simpler and faster.