removing non duplicate data

[freeman]

I have a worksheet that has one column of data, most of it is repeated. What
I would like is to have a formula that will take the data in column one and
take out the non repeated data and put that in column two.

 

[Otto Moehrbach]

No formula will do that. Use Data - Filter - Advanced Filter and specify
Unique records. That will display only the unique records in Column A.
Copy that and paste it to Column B. HTH Otto