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. Extract Trader Joes Grocery Store Location Data For InsightsAuthor: FoodDataScraper
2. Publix Grocery Data Scraping Services For Real-time Tracking
Author: Actowiz Solutions
3. Scraping Food Delivery Data From Menulog For Business Intelligence
Author: Food Data Scrape
4. Why Transportation Companies Need Embedded Bi Tools – Helical Insight
Author: Vhelical
5. Time Attendance System Singapore | 1 Sgd Mobile Attendance Easy Setup
Author: guard
6. Employee Gps Mobile Time Attendance | 1 Sgd Per Month Payroll Integration
Author: guard
7. Gps Nfc/qr Guard Tour Patrol – Free Payroll – 30sgd Monthly Subscription
Author: guard
8. Elearning Security Officers & Free Payroll – 30sgd Monthly Subscription
Author: guard
9. Guard Tour System & Security Patrol – 30sgd Per Month Plan
Author: guard
10. Top Benefits You Gain When You Hire Oracle Sql Developer For Efficient Data Management
Author: Stellanova GlobalTech
11. Discover How Microsoft Purview Compliance Manager Simplifies Cmmc Compliance For Gcc High Environment
Author: ECF Data
12. Scraping Food Ingredient Info From Sydney, Australia, For Insights
Author: Food Data Scrape
13. Best Website Design Perlis | Rm499 Unlimited Pages – Creative Solutions
Author: mobiwork
14. Rm499 Unlimited Pages Custom Web Application Development | Quality Guaranteed
Author: mobiwork
15. Flexible Work Arrangement & Free Payroll – 1sgd Monthly Pricing
Author: mobiwork