Thursday, February 16, 2012

How to Delete Duplicates in Excel


1. Place your list into Excel. Whether you type it or import it from another location, make sure it is in Excel and each entry is in its own row. This will let the program automatically delete duplicate entries.
2. Click the 'Data' tab on the top of the screen. This will bring up the 'Data' menu. Look for the 'Data' tools section of the toolbar.
3. Select the range of cells containing duplicates. If there are data in adjacent rows or columns, Excel will ask if you want to include that data.
4. Click on the 'Remove Duplicates' button. A dialog box will come up asking which column you want to remove the duplicates. If there are data in adjacent rows or columns, Excel will ask if you want to include that data. Make sure the correct column is chosen. If you are looking to delete a duplicate that corresponds to an entire row, make sure you only choose the one row or column with the data you want to delete.
5. Click 'OK.' The duplicate data will be deleted and a dialogue box will appear informing you of how many duplicate entries were deleted and how many unique values remain. Click 'OK' to return to the spreadsheet to continue working.

Blogger news