Friday, February 25, 2011

How to Check for Duplicate Text in Excel


Excel 2007
1. Go to Microsoft Excel 2007 and open the worksheet you want to check.
2. Insert a column header for the column you’re checking. Then select the column and click on the “Data” tab.
3. Click on “Remove Duplicates” in the “Data Tools” group.
4. Place check marks by “My data has headers” and the columns you want to verify. Then click on “OK” to remove the duplicates.
Excel 2003
5. Open your document in Excel 2003. Make sure the column has a column header, then select the column you want to verify.
6. Select “Data,” “Filter” and “Advanced Filter” from the toolbar.
7. Accept the selected range or use your own. To change the list range, click on the “List Range” button and select your range on the spreadsheet.
8. Select “Copy to another location” under “Action” and place a check mark by “Unique records only.” Click on the “Copy to” button and choose the location where the updated data is placed. Then click on 'OK' to apply the update.
9. Double-check that the updated list looks correct, then select the old column and delete it.

Blogger news