123ArticleOnline Logo
Welcome to 123ArticleOnline.com!
ALL >> Computers >> View Article

Deleting Duplicates In A Jiffy

Profile Picture
By Author: Excel Everest
Total Articles: 9
Comment this article
Facebook ShareTwitter ShareGoogle+ ShareTwitter Share

Some people, it would seem, will just not get it. Ever.

So on the day of the all hands meeting at your firm, you'd put up a small Excel file outside the entrance, with just one column to be filled: names of people attending. All that people had to do was enter their name while entering the room. That was it, so that you could have a quick and ready estimate of the number of people who attended. Simplicity itself, right?


But no! No system, it would seem, is fail proof.

Because a quick glance shows you that certain geniuses have entered their name multiple times.
Apparently, going out for a cup of coffee and coming back in implies having attended the meeting twice. Sigh.


Well, the damage is done, and there is no use crying over spilt milk. Correcting for multiple entries is your job, so how do you do it? That's what this Excel tutorial focuses upon, and the good news is - it just takes one simple click!


Having selected the first row in the column for which duplicates need to be removed, head over to the ...
... data tab, and look for the "Remove Duplicates" button.

Clicking on it will give rise to a new window:

And clicking OK will, as if by magic, remove all those pesky duplicates.

There - what might have taken hours for a firm with hundreds of employees now takes seconds. Leaving you free to, say, go for a cup of coffee yourself.

And what a very pleasant thought that is, isn't it?

About Author:

Excel Everest provides an interactive excel tutorial course. The tutorial covers 41 topics, 155 exercises, 399 buttons, and 87 videos that are built right into an Excel file. For more details please visit http://www.exceleverest.com/blog/post/Deleting-Duplicates-in-a-Jiffy.aspx.

Total Views: 206Word Count: 288See All articles From Author

Add Comment

Computers Articles

1. How To Improve The Security Of Android App?
Author: goodcoders

2. How To Earn Money From Free Apps?
Author: goodcoders

3. How Artificial Intelligence Is Revolutionizing Accounting?
Author: goodcoders

4. Explain About Web Application Architecture: Components, Types, Best Practices
Author: goodcoders

5. Complete Guide To Fitness App Development
Author: goodcoders

6. Erp For Small And Big Enterprise
Author: AITS Software

7. Top Software Development Company Melbourne
Author: Technothinksup Solutions

8. The Devops Revolution: Accelerating Innovation In The Digital Age
Author: basheer ansari shaik

9. How Ai Is Transforming Software Development
Author: Technothinksup Solutions

10. How To Do Web Scraping With Ruby?
Author: goodcoders

11. How Mobile Apps Blooming In The Fashion Industry?
Author: goodcoders

12. How Cloud Computing Helps In The Field Of Mobile App Development?
Author: goodcoders

13. The Importance Of Cybersecurity In The Digital Age
Author: Mohammad Arsh

14. First-ever ‘identity Management Day’ Is April 13, 2021
Author: Reinfosec

15. Top 5 Project Management Software Of 2025
Author: Ben Gross

Login To Account
Login Email:
Password:
Forgot Password?
New User?
Sign Up Newsletter
Email Address: