create a separate list for unique records

[eva cheng]

I have a column of data with records may duplicate, how can i create a
separate list in other area of the worksheet for unique records only, is it
possible to do this without macro.

Thanks a lot

 

[Bob Phillips]

Use Data>Filter>Advanced Filter, it has a unique records option.

 

[Malin D]

If you have Excel 200 or later yes - Choose Insert, Table and Remove
duplicates.

 

[ozgrid.com]

Use advancedfilter for uniques and copy to another location.