| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to remove duplicated items from a list?
Does anyone have any suggestions on how to remove duplicated items from a list?
For example, there is a list of number under column A, and I would like to remove any duplicated items and lists it under column B. Does anyone have any suggestions? Thanks in advance for any suggestions Eric |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to remove duplicated items from a list?
On May 14, 11:05*am, Eric wrote:
Does anyone have any suggestions on how to remove duplicated items from a list? For example, there is a list of number under column A, and I would like to remove any duplicated items and lists it under column B. Does anyone have any suggestions? Thanks in advance for any suggestions Eric go to DATA -- Filter -- Advance Filter give copy to another location (select the col B) and unique record only |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to remove duplicated items from a list?
Thank you for your suggestions
I don't want to use DATA -- Filter -- Advance Filter, do you have any other approach? Thank you for any suggestions Eric " wrote: On May 14, 11:05 am, Eric wrote: Does anyone have any suggestions on how to remove duplicated items from a list? For example, there is a list of number under column A, and I would like to remove any duplicated items and lists it under column B. Does anyone have any suggestions? Thanks in advance for any suggestions Eric go to DATA -- Filter -- Advance Filter give copy to another location (select the col B) and unique record only |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Remove Duplicates; How can I get a list of items removed? | Excel Discussion (Misc queries) | |||
| How can I add duplicated items in a list? Help! | Excel Discussion (Misc queries) | |||
| How do I remove duplicated information in 2 columns of Excel? | Excel Discussion (Misc queries) | |||
| Remove ALL duplicated records, leaving behind NONE | Excel Discussion (Misc queries) | |||
| How do I remove items listed in a pivot table drop down list box | Excel Discussion (Misc queries) | |||
Linear Mode
