How to Delete Duplicate Rows in Excel Based on One Column

Save

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.

References

  • Photo Credit Pixland/Pixland/Getty Images
Promoted By Zergnet

Comments

You May Also Like

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!