Need Help - Same text in column to make list

Pl see file. In A17 and copied down,

Please Login or Register  to view this content.

Yes. It is better to learn things.

@kvsrinivasamurthy

Learning requires personal effort, but also good teachers - a good teacher will be prepared to explain things if asked to do so. The OP has asked you to explain the formula you provided - please do so. Thank you.

Sorry for the delay
=IFERROR(INDEX($A$3:$A$12,AGGREGATE(15,6,ROW($A$3:$A$12)/(COUNTIF($A$16:$A16,$A$3:$A$12)=0),1)-ROW($A$2)),"")

(COUNTIF($A$16:$A16,$A$3:$A$12)=0

The count function will count for The names in A3:A12 in A16 ( above the cell of the formula)
Result array is 0 if Name exists 1 if does not exist.

ROW($A$3:$A$12)/(COUNTIF($A$16:$A16,$A$3:$A$12)=0

Row numbers Of A3:A12 are divided by countif array
Result is RowNumbers for names not available,Error for available.
Aggeregate function selects the smallest row number, because of 15,6. 5 select lowest, 6 neglet errors.

-ROW($A$2))
This will Deduct 2 from row number to get position of Index arrray.

INDEX($A$3:$A$12,
Resultant row number is used to select the data in index.That is the final Data.

=IFERROR(......),"")
In case there is no data available( the row number is higher than index array ) If error function returns "" (blank)