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

Add Comment

Computers Articles

1. Access Review Fatigue Is Not A People Problem. It Is A Design Problem
Author: Tushar Pansare

2. Which Is The Best Data Recovery Service Provider In Delhi?
Author: Stellar Data Recovery India

3. Microsoft Access 2024 Vs. Microsoft Excel 2024: Which Tool Should You Use?
Author: davudobuya55

4. When Identity Governance Becomes An Audit Ritual
Author: Mansoor Alam

5. Power Virtual Agents To Microsoft Copilot studio
Author: brainbell10

6. Dream11 Clone App Guide For The Upcoming Ipl Season
Author: Jorden James

7. Computer Network Tutorial: Step-by-step Guide To Networking Fundamentals
Author: Tech Point

8. Ai Video Creation Services In Chandigarh | Growchip Ai Technologies
Author: AI Video Creation Services

9. Why Online Privacy Matters More Than Ever In 2026
Author: Faraz

10. Spark Matrix™: Data Integration Tools
Author: Umangp

11. D365 Consultant Business Success
Author: brainbell10

12. Medical High-end Touch Monitor From Fortec Integrated
Author: FORTEC Integrated GmbH

13. Why Rugtek Ls3002 Is Best For Retail Barcode Scanning
Author: prime pos

14. Spark Matrix™: Conversational Commerce
Author: Umangp

15. Multi-path Cellular Aggregation | Cellular Sd-wan India | Smoad
Author: SMOD

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