Hi,

Select you column of data then
Data|Filter|Advanced filter
Select 'Copy to another location'
Type the address of the topmost cell in the destination box or navigate to it
Leave criteria box empty
check unique records only
Click OK

Mike

"Ajit Munj" wrote:

I have over 3000 values in column 1 which have duplicate values. I want to
copy only unique values in another column. How Can I do so?
--
Knowldege is Power