Excel Shortcuts

FINDING AND REMOVING DUPLICATES IN EXCEL

FINDING AND REMOVING DUPLICATES IN EXCEL

Have you ever encountered a situation where you see a lot of duplicated data in Excel, but don’t even remember copying it? This happens to all of us at some point. Finding and removing such duplicated data in your spreadsheet can take a lot of time. Instead, use the following tricks for finding and removing duplicates. Let’s get started!

How to Find Duplicates in Excel

1. To find duplicates, we will use the Conditional Formatting function. In our example below, we want to check if any name has been repeated. First, select the Name column (A1:A15).

2. Click on the Conditional Formatting option available on the right-hand side of the Home tab. Alternatively, you can use the shortcut key: Alt + H + L.

3. When you click on the Conditional Formatting dropdown, you will see various options. Select the first option, “Highlight Cells Rules,” and then choose the sub-option “Duplicate Values.”

Talk to our experts now!

4. You will see a Duplicate Values dialog box, where you can select your formatting option. In our case, select “Light Red Fill with Dark Red Text.”

5. Click OK, and you will see that the duplicate names have been highlighted in red.

How to Remove Duplicates in Excel

1. We will use the same example as above to learn how to remove duplicates. To remove duplicates, select any cell within the data range, and then select the “Remove Duplicates” option from the Data tab in the ribbon. You can also use the shortcut ALT + A + M.

2. After clicking on “Remove Duplicates,” a dialog box will appear. It will automatically have your column headers selected. Choose the columns from which you want to remove duplicate values. In our case, we will select all columns, which means that if the data in all three columns is duplicated, the entire row will be deleted. (Rows with blue cells won’t be deleted since the age values are different.)

3. After pressing OK, all the duplicate values will be removed. A pop-up window will appear, informing you about the duplicates removed and the unique values that remain. As mentioned earlier, “JKL” remains since the age mentioned is different.

4. What if you want to delete all values with the same name and gender, irrespective of their age? Well, it’s simple. In the second step, just uncheck the box for age.

5. After clicking OK, you will see that even the row with “JKL” as the name has been deleted.

If you have any queries or suggestions, please feel free to mention them in the comments box below, and we will get back to you at the earliest.

You know why we have given such useful tips in the form of a blog about Excel?

It’s because Excel is very useful in the financial industry. You may ask how it is useful. Excel is used in creating financial models, and financial models are useful to predict the future consequence of any present initiative taken by the company. So that’s how it’s useful.

Financial modeling is a very useful skill, and we swear by it. People working in this sector know, as they have witnessed in their work life, how practical application of the financial concepts learned is important. If you are looking for a trusted training partner in this journey of building financial models, then you are at the right place.

Talk to our experts now!

We at EduPristine provide coaching as well as end-to-end career support for the financial modeling course. Not only that, but our financial modeling course also provides joint certification with the BSE Institute Ltd . The most important tool that has gotten popular in recent times, the Power BI module, has been included in the financial modeling course curriculum, which tells that we are always abreast of the market trends.

The most important part about any course is the faculty quality, and we have really aced the process of selecting the faculty. Our faculty not only have the subject knowledge, but they also possess rich experience of over 15 years in the corporate market. This helps them impart the practicalities that students may face in the future after the course completion.

Our Flexibility Aspect is Worth Applauding

We not only provide live virtual classes in the name of flexibility, but we have also equalized the prices of both live lectures as well as the physical classroom so that students don’t face differential payment amounts when they think of switching from one mode to another. We also provide recordings of live lectures so that students who miss the class can catch up with the happenings and curriculum at their own pace. We also give students the freedom to attend ‘n’ number of batches until they exhaust their course validity.

Talk to our experts now!

For all the administrative issues, we provide 7-days-a-week customer care support. To make our students ready for the real job market, we also provide them with soft skills training and assist them in their placement.

Check Our Students Testimonials

We request you to go through our testimonials page to listen to the experiences of our alumni base and check for our credibility through their words. Also, you can book a free career counseling call with our experts, who are ready to help you guide through the financial modeling course details , and with anything that’s stopping you from making a quick decision for yourself.

Happy learning!

hitesh patil

Interested in this topic?

Recent Posts

How to Become a CPA Without a Degree in Accounting.

Hello, and welcome back to our latest blog. Have you ever wondered if you could…

14 hours ago

How Critical is the Role of CFOs in Mergers and Acquisitions

How Critical is the Role of CFOs in Mergers and Acquisitions? Hello, and welcome back…

2 days ago

The Role of Artificial Intelligence in Accounting and Finance | EduPristine

The Role of Artificial Intelligence in Accounting and Finance | EduPristine Welcome back, learners, to…

3 weeks ago

Role Of CFP® In Bridging the Financial Literacy Gap in India | EduPristine

Role Of CFP® In Bridging the Financial Literacy Gap in India | EduPristine Welcome back,…

3 weeks ago

A Day in The Life of a Financial Risk Manager ® (FRM®) | EduPristine

A Day in The Life of a Financial Risk Manager ® (FRM ®) | EduPristine…

1 month ago

How Much Does an US CMA Professional Earn in India by EduPristine

How Much Does a US CMA Professional Earn in India? Hello, and welcome back to…

1 month ago