Copy text from cells to another sheet

[Yaniks]

Hi,

I have coloumn I with different text in cells, however, there may be duplicate entries; so I cannot copy & paste the whole coloumn.

I would like to have the text moved to a different sheet, without the duplicates.

Is this possible?

 

[FormR]

Hi, welcome to MrExcel!

Assuming you are on a post 2003 system, you could copy the entire column and then use "Remove Duplicates" from the "Data" tab on the copied column.