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.
Open Microsoft Excel 2010
- Select the column with DUPLICATE Records.
- Go to Filter | Advanced Filter.
- 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.
- Click the Checkbox Unique Records.
- Click OK.