Removing Duplicates in Excel 2008

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 …

Read more

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. …

Read more