How to remove duplicates in Excel

Some times we may have a list of ,Account codes, Security pass code, Surnames or Departments where there should be no duplicates.

  1. Select the cells with the duplicate values
  2. Go to Data tab/ Data Tools group
  3. Select Remove Duplicatesremove-dup

Related Topics

Dynamic data for pivot tables

Format as Table Feature in Excel

Excel Course


About Customised Computer Courses Sydney - Sutherland Shire M 0414 417 059

On-Site customised computer training courses Sydney - Sutherland Shire. Excel, Word,Power Point, Access, Outlook, Visio, Publisher, Excel VBA e: m: 0414 417 059
This entry was posted in Excel and tagged , , , , , , . Bookmark the permalink.

Leave a Reply

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

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

Google+ photo

You are commenting using your Google+ 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 )

Connecting to %s