| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to remove duplicates?
In my column of 63000 entries their are some duplicates. Is their a simple
way of removing them? Thank you. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to remove duplicates?
DataFilterAdvanced Filter.
Unique records only and copy to another location. Delete original column. You could copy the uniques to another worksheet if you start from that worksheet. See Debra's site for instructions. http://www.contextures.on.ca/xladvfi...html#ExtractWs Gord Dibben MS Excel MVP On Fri, 25 Jan 2008 13:39:00 -0800, Lakewoodsale wrote: In my column of 63000 entries their are some duplicates. Is their a simple way of removing them? Thank you. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to remove duplicates?
If you're using Excel 2007...
Data tabData ToolsRemove duplicates One of the more useful new features of Excel 2007! -- Biff Microsoft Excel MVP "Lakewoodsale" wrote in message ... In my column of 63000 entries their are some duplicates. Is their a simple way of removing them? Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need Assistance: Average/Remove Duplicates | Excel Discussion (Misc queries) | |||
| Merge and remove duplicates? | Excel Worksheet Functions | |||
| how to remove duplicates ONLY within the same category | Excel Discussion (Misc queries) | |||
| Remove duplicates | Excel Discussion (Misc queries) | |||
| compare two columns and remove duplicates | Excel Worksheet Functions | |||
Linear Mode
