ALL >> Computers >> View Article
Deleting Duplicates In A Jiffy
![Profile Picture](https://www.123articleonline.com/images/avatar-default.jpg)
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.
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