Sunday, November 24, 2013

How to Remove Duplicate Values in Excel

How to Remove Duplicate Values in Excel:



1. Select the range of cells B2 to C16
2. On the Data tab, in the Data Tools group, click Remove Duplicates 


3. Click OK


A message is displayed indicating how many duplicate values were removed and how many unique values remain, or if no duplicate values were removed.

4. Click OK
Post a Comment