is there a formula for this ?

[wanalearn]

I have in column ''A'' names repeated a few times I want in column 'B'' all the names from column a one time 

[#2]

@wanalearn 

=IF(COUNTIF($A$2:A2,A2)=1,A2,"")

You can try this formula.

 

[#3 · Accepted solution]

@wanalearn If you have Excel 365 there is a formula specifically for that:

=FILTER(UNIQUE(A:A),UNIQUE(A:A)<>0)