create a separate list for unique records
 

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
--
eva cheng

create a separate list for unique records
 

Use DataFilterAdvanced Filter, it has a unique records option.

--

HTH

Bob

"eva cheng" wrote in message
...
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
--
eva cheng

create a separate list for unique records
 

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

Malin D
Office consultant/Trainer


"eva cheng" wrote:

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
--
eva cheng

create a separate list for unique records
 

Use advancedfilter for uniques and copy to another location.



--
Regards
Dave Hawley
www.ozgrid.com
"eva cheng" wrote in message
...
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
--
eva cheng