SOLVED

is there a formula for this ?

Occasional Contributor

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

2 Replies

@wanalearn 

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

You can try this formula.

repeated.JPG 

best response confirmed by wanalearn (Occasional Contributor)
Solution

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

 

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