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: 232Word Count: 288See All articles From Author

Add Comment

Computers Articles

1. Fantasy Sports Analytics Through Myteam11 App Real-time Data Extraction
Author: i web data

2. Extract Kroger Grocery Store Locations Data For Expansion
Author: FoodDataScrape

3. What Benefits Can Businesses Gain From Doordash Menu Data Scraping?
Author: FoodDataScrape

4. Amazon Fresh Scraping Api Helped Client To Enhance Market Insights
Author: FoodDataScrape

5. Leverage Web Scraping H-e-b Grocery Chain Data
Author: FoodDataScrape

6. It Gadgets Online: Powering India’s Tech Enthusiasts With Premium Pc Components And Gaming Gear
Author: ITGadgetsOnline

7. Reliable Incubator Monitoring And Refrigerator Alerting Solutions For Critical Environments
Author: Chris Miller

8. Extract Total Wine Data For Flavor And Ingredient Insights
Author: FoodDataScraper

9. How To Utilize Firebase Dynamic Links To Integrate Deep Linking On Ios?
Author: davidjohansen

10. How To Start Web Automation Testing Using Selenium And Python?
Author: davidjohansen

11. How To Perform Firebase A/b Testing On Ios?
Author: davidjohansen

12. Python Pandas Tutorial – A Simple Guide For Beginners
Author: Tech Point

13. Scrape Dubai Restaurant And Café Contact Info
Author: FoodDatascrape

14. Best Online Computer Store In India | Itgo - Itgadgets Online
Author: ITGadgetsOnline

15. Getir Grocery App Data Scraping - Benefits & Best Practices
Author: FoodDataScrape

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