Posted in Microsoft

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
Posted in Free Whitepapers-Ebooks

Microsoft Project 2010– Free Quick Reference Card


You can Use Linkedin Credentials to Download.

Microsoft Project 2010-- Free Quick Reference Card
Microsoft Project 2010– Free Quick Reference Card

This Microsoft Project 2010 Quick Reference offers the fundamentals, as well as tips for using the various applications within the program.
Related Reference Cards:

Computer

Microsoft 2011

Microsoft 2010

Apple

Others

Vodpod videos no longer available.

Posted in Free Whitepapers-Ebooks

Microsoft Office 2010– Free Quick Reference Card


You can Use Linkedin Credentials to Download.

Microsoft Office 2010-- Free Quick Reference Card
Microsoft Office 2010– Free Quick Reference Card

This Microsoft Office 2010 Quick Reference provides shortcuts, tips, and tricks for the popular application suite.
Related Reference Cards:

Computer

Microsoft 2011

Microsoft 2010

Apple

Others

Vodpod videos no longer available.

Posted in Free Whitepapers-Ebooks

Microsoft Outlook 2010 – Free Quick Reference Card


You can Use Linkedin Credentials to Download.

Microsoft Outlook 2010 - Free Quick Reference Card
Microsoft Outlook 2010 – Free Quick Reference Card

This Microsoft Outlook 2010 Quick Reference provides shortcuts, tips, and tricks for the e-mail management software.

Use it to brush up on the basics and to find alternate methods to your favorite commands. This printable quick reference is yours to use, distribute, and share at your organization!

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

Vodpod videos no longer available.

 

Posted in Free Whitepapers-Ebooks

Microsoft Visio 2010 – Free Quick Reference Card


Microsoft Visio 2010 – Free Quick Reference Card

 This Microsoft Visio 2010 Reference provides shortcuts, tips, and tricks for the popular diagramming software. Use this reference to brush up on the basics and to find alternative methods to your favorite commands.

Cloud Computing – Download Free EBooks and Whitepapers
Java – Download Free EBooks and Whitepapers
Windows – Download Free EBooks and Whitepapers
Microsoft Visio 2010 - Free Quick Reference Card
Microsoft Visio 2010 – Free Quick Reference Card

This printable quick reference is yours to use, distribute, and share at your organization!

Along with this free reference card, if you are eligible, you will also receive a 30-day trial of CustomGuide training, including over 7,000 Online Skills Assessments and Interactive Tutorials.

To Download Click Here.

 

Posted in Free Whitepapers-Ebooks

Microsoft Access 2010 – Free Quick Reference Card


Microsoft Access 2010 – Free Quick Reference Card

This Microsoft Access 2010 Reference provides shortcuts, tips, and tricks for the popular database management system. Use this reference to brush up on the basics and to find alternative methods to your favorite commands.

Cloud Computing – Download Free EBooks and Whitepapers
Java – Download Free EBooks and Whitepapers
Windows – Download Free EBooks and Whitepapers
Microsoft Access 2010 - Free Quick Reference Card
Microsoft Access 2010 – Free Quick Reference Card

This printable quick reference is yours to use, distribute, and share at your organization!

Along with this free reference card, if you are eligible, you will also receive a 30-day trial of CustomGuide training, including over 7,000 Online Skills Assessments and Interactive Tutorials.

To Download Click Here.