Duplicate data

[Paula]

my column is long list with much same entries

i want to delte all duplicate entries in column

is easy way?

ty

 

[Bernard Liengme]

Select all the data
Use Data | Filter | Advance Filter | Unique records only
Copy the visible cell to another part of worksheet (or another worksheet)
best wishes

 

[Paula]

thank you sir

 

[Evgeny Grischenko]

Hello!
In such cases I prefer to use a special add-in for removing duplicate cells
in tables and workbooks:
http://www.office-excel.com/excel-addins/remove-duplicates-excel.html
Maybe it helps you too.
Best regards,
Evgeny