| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create separate list of only selected data | Excel Discussion (Misc queries) | |||
| Create a separate list of duplicates | Excel Discussion (Misc queries) | |||
| how to get the number of unique records in a list | Excel Worksheet Functions | |||
| Finding unique records from a list. | Excel Discussion (Misc queries) | |||
| How do I create a validation list on a separate worksheet? | Excel Worksheet Functions | |||
Hybrid Mode
