MS Excel Secrets - Filtering Unique Records

Sometimes,you have a list of items in Excel that I would like to filter through the data to get rid of the duplicates.

One way to find only unique records is to use the “Remove Duplicates” feature.

If you are in Excel 2007, you can do this by clicking on the Data tab and then choose the “Remove Duplicates” button.

Read lots more MS Excel Secrets

You will be given a list of the columns in your Excel sheet. Select the columns you would like to search in to find the unique records. Then click OK.

Make sure that you click the “My Data Has Headers” check-box if your have column headings, so that they do not get filtered, too.

Related Posts:
How to Convert PowerPoint to Flash Flipbook

Hot in weekRecentComments

Recent

0 11-17-2016

C Programming - Data Structure Interview Questions Answer

0 11-17-2016

We have started series of C programming Q&A for job interview for freshers.Computer / IT Engineering Professionals and Students alike will be benefited.We recommend our user to go through pre...

0 11-17-2016

1 9-20-2016

C Programming Question Answer

1 9-20-2016

We have started series of C programming Q&A for job interview candidates.Engineering Professionals and students alike will be benefited.We recommend our user to go through previous post to enha...

1 9-20-2016

0 9-12-2016

Java Objective Multiple Answer Questions Bank

0 9-12-2016

We have chosen Java Oracle J2EE, J2SE, Net-beans, JVM ( Java Virtual Machine ) as our readers choice.We have created Objective Type Multiple Answer Question Collection that are frequent in job inte...

0 9-12-2016

0 9-8-2016

Java Question Bank Objective Q&A

0 9-8-2016

Here we have collected frequently asked question in job interviews.We have chosen Java as our readers choice.You will find these helpful.We encourage our Readers to send in their suggestion. If re...

0 9-8-2016

0 8-30-2016

C Question Bank

0 8-30-2016

We have started series of C programming Question bank for job interview candidates.Engineering Professionals and students alike will be benefited.We encourage our readers to provide feedback and as...

0 8-30-2016

Comments

7-1-2017

Anonymous:

7-1-2017

Technology is always being the vital part of evolution either mobile phones or computer all are the part of it. Electronics have made things so easy and reliable for human being s. very few schools in...

7-1-2017

5-22-2017

Anonymous:

5-22-2017

A detailed and complete knowledge guide for fresher's to crack their interviews in Embedded Programming. Looking for a job contact <a href="http:/celebratejobs.com/>celebratejobs</a&...

5-22-2017

4-9-2017

YouLoseBellyFat:

4-9-2017

visual basic example codes

4-9-2017

2-19-2017

App Development Mumbai:

2-19-2017

It was very useful for me. Keep sharing such ideas in the future as well. This was actually what I was looking for, and I am glad to came here! Thanks for sharing the such information with us.

2-19-2017

9-25-2016