Delete duplicate text in Microsoft Excel 2010 and Excel 2007


How to delete duplicate text in Microsoft Excel 2010 and Excel 2007 from single column?

Microsoft Excel is a spreadsheet application developed by Microsoft having features such as graphing tools, calculation, a macro programming language called Visual Basic, and pivot tables for Applications. It comes as a part of Microsoft Office suit. It comes with all basic features available in spreadsheet. It is more useful in data storage and communication. There are many requirements from users on how to delete duplicate data from the worksheet. You can use find or replace functionality as well. But what if you want to remove all duplicate data available in single column without taking pain of find and replace duplicate content manually?

We can do it by using Advanced Filter feature. Let’s say you are using Google Web Master Tools to monitor your Blog and you download list of Crawl Errors in a Excel sheet format. You would like to find out unique errors reported by Google Web master tools. In this case, you can easily find it out with the use of Advanced Filter.

Cloud Computing – Download Free EBooks and Whitepapers
Java – Download Free EBooks and Whitepapers
Windows – Download Free EBooks and Whitepapers

Open Microsoft Excel 2010

  1. Select the column with DUPLICATE Records.
  2. Go to Filter | Advanced Filter.
Advanced Filter in Excel Sheet - Microsoft Excel 2010
Advanced Filter in Excel Sheet – Microsoft Excel 2010
  1. Click in the Copy To Another Location text box, then click on a cell in the same worksheet of Microsoft Excel 2010 Workbook where you want to store the new list.
  2. Click the Checkbox Unique Records.
  3. Click OK.

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s