Max showed this the other day

In c1 type; =IF(B1="","",IF(ISNUMBER(MATCH(B1,A:A,0)),"",ROW() ))
in d1 type; =IF(ROW()COUNT(C:C),"",INDEX(B:B,SMALL(C:C,ROW()) ))

drag both formulas down as far as required C to end of data and d until no
further results are shown.

Peter

"Mik" wrote:

Hello, looking for some help with the following:-
I have a list of names within Column A, some of which are repeated
numerous times.
What i require, is to list in Column B each of the names shown in
Column A (once only), so those names that are repeated, are only
displayed once.

Col A Col B

A A
B B
C C
B D
D E
E F
A
A
F