September 19, 2013

Remove Duplicate Cells in Microsoft Excel 2010

When compiling data from several different locations we are bound to end up with duplicate information.  Instead of scrolling through this data trying to find and delete the duplicate data, Excel now has a tool to help you do this with just a few simple clicks! First select all the data you would like Excel to check.  Then click the Data tab, and in the Data Tools group click Remove Duplicate Cells.  In the pop up window add a check box next to the column(s) that might contain duplicates. If your data has headers, make sure that box is checked and then click ok.  Lastly a pop up screen will appear telling you how many duplicates were removed.

No comments:

Post a Comment