Microsoft Excel is spreadsheet software that helps you organize, chart and modify large amounts of data. If you have a single column of data (in other words, a list), you may accidentally enter duplicate data during the data entry process. Finding the duplicate entry by hand can be a time consuming process, especially if you have thousands of entries in a column. Excel's Data Sorting function can help you locate and remove duplicate entries.
Things You'll Need
- Excel 2007
Select the entire column of data by left clicking on the top cell and dragging the cursor to the bottom cell.
Click on the "Data" tab and select "Filter > Advanced." Click the "Filter the list, in-place" radio button and check the box next to "Unique records only." Click the "OK" button.
Open the Office Clipboard by pressing the "Home" tab and choosing "Clipboard."
Hold down the Crtl and C keys at the same time to copy the cells into the clipboard.
Click on the "Filter" tab to restore the original cell data.
Paste the modified cell contents from the clipboard into the cells by clicking on the contents in the clipboard.
Tips & Warnings
- Make sure the column cells remain highlighted as you move through the steps. If the column is not highlighted, redo Step 1.
- Column headers are required to use the filter function. If you do not use column headers you will receive an error message.
- Photo Credit Pixland/Pixland/Getty Images
How to Remove Duplicate Rows From an Excel Spreadsheet
If one row shares the exact values of one or more other rows, all are called duplicate rows. You can use Excel's...
How to Remove Duplicates from Excel Macro
A duplicate entry in Microsoft Excel is an entry in a column or row that matches other entries in the same column...
How to Delete Excel Rows Based on Date
To get the most out of Microsoft Excel, you have to learn how to use macros and VBA programming. As you build...
How to Remove Duplicate Values From a List in Excel
Excel lets you sort massive amounts of data in a spreadsheet. As your list grows, you may start receiving some duplicate values....