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
"freeman" wrote in message
...
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.