On the Data tab, in the Data Tools group, click Remove Duplicates. Select the range of cells, or make sure that the active cell is in a table. To remove duplicates, you must remove both the outline and the subtotals first. Excel 20 have the Remove Duplicates feature. Excel 2008 for Mac requires more work to remove duplicate values in a data set because of it’s lack of features.
Hello, The easiest method to do this task is to sort out the sheet and remove the duplicates manually. How To Remove Duplicates In Excel For Mac 2011 Average ratng: 3,9/5 9869 votes
