ALL >> Computers >> View Article
Deleting Duplicates In A Jiffy
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. Market Forecast: Conversational Ai For Intelligent Contact CenterAuthor: Umangp
2. Complete Guide To Ipv4 Leasing, Lease Ipv4 Address & Ipv4 Address Rental By Elite Server Management
Author: Elite Server Management
3. B2b Marketer’s Guide To Onboarding A Lead Agency Without Losing Months
Author: demandify
4. Why Choose Sataware?
Author: brainbell10
5. Best Laptop Service In Hyderabad For Fast Laptop And Computer Repair Near Me
Author: Vfix4u Seo
6. Microsoft Dynamics 365 Upgrade Process
Author: brainbell10
7. Transforming The Future With Legacy Migration: How Tech Gazebos Drives Modernization Success
Author: Tech Gazebos
8. The Hidden Cost Of Treating Iam As A Governance Platform
Author: Tushar Pansare
9. Sqlite Development & Integration Services In Usa
Author: davidjohansen
10. Rp80 Thermal Printer For Pos: Full Overview
Author: pbs
11. Real-time Vehicle Inventory Monitoring
Author: Actowiz Metrics
12. Software Testing & Qa
Author: davidjohansen
13. Market Forecast: User Authentication
Author: Umangp
14. Dell Laptop Repair In Wadala
Author: Laptop Repair Mumbai
15. Data Mining Tutorial: A Complete Guide To Concepts, Techniques, And Applications
Author: Tech Point






