Formula to copy from one column to another but if the info is the same copy info once then lave other cells blank

[archie11236]

I am looking for a formula to copy from one column to another but if the info is same copy info once then lave other cells blank. Example below

Column A -----------------------------Column B


OBSESSION by Calvin Klein----------OBSESSION by Calvin Klein
OBSESSION by Calvin Klein
OBSESSION by Calvin Klein
OBSESSION by Calvin Klein
OBSESSION by Calvin Klein
OBSESSION by Calvin Klein
OBSESSION by Calvin Klein
OBSESSION by Calvin Klein
OBSESSION by Calvin Klein
OBSESSION by Calvin Klein
OBSESSION by Calvin Klein
OBSESSION by Calvin Klein
OPIUM by Yves Saint Laurent --------- OPIUM by Yves Saint Laurent
OPIUM by Yves Saint Laurent
OPIUM by Yves Saint Laurent
OPIUM by Yves Saint Laurent
OPIUM by Yves Saint Laurent
OPIUM by Yves Saint Laurent
OPIUM by Yves Saint Laurent
OPIUM by Yves Saint Laurent
ORGANZA by Givenchy -----------------ORGANZA by Givenchy
ORGANZA by Givenchy
ORGANZA by Givenchy
ORGANZA by Givenchy

 

[mrshl9898]

Assuming these start in A1, in B1:

=IF(COUNTIF($A$1:A1,A1)=1,A1,"")

 

[Weazel]

maybe something like...

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