Friday, October 2, 2015

Remove Duplicates

This example teaches you how to remove duplicates in Excel. Go here to only find duplicates.
1. Click any single cell inside the data set.
2. On the Data tab, click Remove Duplicates.
Click Remove Duplicates

The following dialog box appears.
3. Leave all check boxes checked and click OK.
Remove Duplicates Dialog Box
Result. Excel removes all identical rows (blue) except for the first identical row found (yellow).
Remove Duplicates Example Remove Duplicates Result
To remove rows with the same values in certain columns, execute the following steps.
4. For example, remove rows with the same Last Name and Country.
5. Check Last Name and Country and click OK.
Select Columns
Result. Excel removes all rows with the same Last Name and Country (blue) except for the first instances found (yellow).
Remove Duplicates Example Remove Duplicates Result

Thursday, October 1, 2015

Welcome