Makes sure you have a header, if not create one, select the data (header
included), do datafilteradvanced filter, select copy to another location
(then select where to copy), then select unique records only and click OK


--
Regards,

Peo Sjoblom



"Kitti" wrote in message
...
Hi,
Could someone tell me how I might remove data (phone numbers) in a column
and only retain one a duplicated number in the column just once?
Basically
needing to remove duplicates.
Thank you