L Lakewoodsale Jan 25, 2008 #1 In my column of 63000 entries their are some duplicates. Is their a simple way of removing them? Thank you.
In my column of 63000 entries their are some duplicates. Is their a simple way of removing them? Thank you.
G Gord Dibben Jan 25, 2008 #2 Data>Filter>Advanced 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/xladvfilter01.html#ExtractWs Gord Dibben MS Excel MVP
Data>Filter>Advanced 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/xladvfilter01.html#ExtractWs Gord Dibben MS Excel MVP
T T. Valko Jan 25, 2008 #3 If you're using Excel 2007... Data tab>Data Tools>Remove duplicates One of the more useful new features of Excel 2007!
If you're using Excel 2007... Data tab>Data Tools>Remove duplicates One of the more useful new features of Excel 2007!
