more info please
will there only be one unique item?
is it text or numbers?
What is definition of unique in this case?
an example would be useful

"Yogi" wrote:

I would like to copy UNIQUE data from a column in a SINGLE CELL