In Excel 2010 there is a button on the Data Tab to "remove duplicates" (maybe a good ideas to copy the original list and compare). This can also be done in Excel 2007 or Excel 2003 - select the list and use Data - Filter - Advanced filter, this gives a dialogue box that you can copy the list to a new location and at the bottom is the check box "unique values only" (no filter is applied). many more topics at:
MS Excel Training Delete Duplicates Toronto, Mississauga
Bert Twomey
MS Excel Training
Showing posts with label Delete Duplicates. Show all posts
Showing posts with label Delete Duplicates. Show all posts
Monday, February 28, 2011
Subscribe to:
Posts (Atom)