Remove Duplicates | Excel Semi-Pro

Remove Duplicates

Different Versions, Different Methods in Excel

July 23, 2010 Intermediate

For the past week I’ve been showing how to remove duplicate values from a data range in Excel. How you go about that task varies, depending on the version of Excel you use. My simple worksheet example used only two columns, and only one had duplicate values. Excel 2010 and 2007 The Remove Duplicates feature […]

Get the full story …

Removing Duplicates in Excel 2008

July 22, 2010 Intermediate

Excel 2008 for Mac requires more work to remove duplicate values in a data set because of it’s lack of features. Excel 2007 and 2010 have the Remove Duplicates feature. Excel 2003 and Excel 2008 for Mac don’t. In my last post I used a formula and the Find box to remove duplicate values in […]

Get the full story …

Removing Duplicate Values in Excel 2003

July 17, 2010 Intermediate
Thumbnail image for Removing Duplicate Values in Excel 2003

I have a worksheet with duplicate values that need to be removed. There are two columns of data, with Date in column A and Weight in column B. The Date values are for each day and extend to the end of June. Some of the Weight values repeat as you can see in the picture. […]

Related Posts Plugin for WordPress, Blogger...
Get the full story …