Finding and Removing Duplicates in Excel
Finding and Removing Duplicates in 8 Steps
How to find duplicates in excel
-
-
For finding the duplicates we shall be using the conditional formatting function. In our example below, we want to find if any name has been repeated. So first we shall select the Name column (A1:A15).
-
-
-
Click on the conditional formatting option available at the right hand side of the home tab. Alternatively, you can also use shortcut key: Alt + H + L.
-
-
-
When you click on the dropdown of conditional formatting, you shall receive various options. Select the first option ˜Highlight Cells Rules’ and the sub-option as ˜Duplicate Values.’
-
-
-
You shall see a duplicate values dialog box, wherein you can select your formatting option. In our case, we select ˜Light Red Fill with Dark Red Text’.
-
-
-
Click on OK and you shall see that the duplicate names have been highlighted in red color.
-
How to Remove Duplicates in Excel
-
-
We shall use the same example as above for learning removal of duplicates. To remove the duplicates, select a random cell and select the option of Remove Duplicates from the data tab in the ribbon. You can also use the shortcut ALT + A + M
-
-
-
After clicking on remove duplicates a dialog box shall appear of remove duplicates. It will automatically have your column headers, select the columns of which you want to remove the duplicate values. In our case we shall select all which means if the data in all three columns is duplicated then the rows shall be deleted. ( The blue ones won’t be deleted since the age is different)
-
-
-
After pressing OK, all the duplicate values are removed, a pop up shall appear informing you about the duplicates removed and the unique values that remain. As mentioned above JKL remains since the age mentioned is different
-
-
- What if you want delete all values which have same name and gender irrespective of their age?? Well simple, in the 2nd step just unmark the age checkbox.
-
- After clicking on OK you will see that even the row with JKL as name has been deleted.
MAKE YOUR CAREER IN
Need more Info?
Tags
- ABOUT FRM COURSE IN INDIA
- ACCA
- ACCA CERTIFICATION
- ACCA COURSE
- ACCA COURSE DETAILS
- ACCA COURSE DURATION
- ACCA COURSE ELIGIBILITY CRITERIA
- ACCA COURSE STRUCTURE AND FEES IN INDIA
- ACCA COURSE SYLLABUS
- ADMISSION TO CFA
- BAT COURSE
- BEST FINANCIAL MODELING COURSE
- BEST FINANCIAL MODELING COURSE IN INDIA
- BEST ONLINE CFA PREP COURSE
- BEST ONLINE FINANCIAL MODELING COURSE
- CFA CERTIFICATION
- CFA COURSE
- CFA COURSE DETAILS
- CFA COURSE DURATION
- CFA COURSE FEES
- CFA COURSE FEES IN INDIA
- CFA COURSE IN INDIA
- CFA COURSE SYLLABUS
- CFA COURSE TRAINING
- CFA FOUNDATION COURSE
- CMA COURSE
- CMA COURSE DETAILS
- CMA COURSE DETAILS IN INDIA
- CMA COURSE DURATION.
- CMA COURSE ELIGIBILTY
- CMA COURSE IN INDIA
- CMA COURSE SYLLABUS
- CPA ACCOUNTANT
- CPA COURSE
- CPA COURSE DETAILS
- CPA COURSE DURATION
- CPA COURSE IN INDIA
- FINANCIAL MODELING
- FINANCIAL MODELING AND VALUATION
- FINANCIAL MODELING COURSE
- FINANCIAL MODELING COURSE IN INDIA
- FINANCIAL RISK MANAGER
- FRM COURSE
- FRM COURSE CERTIFICATION
- FRM COURSE CURRICULUM
- FRM COURSE DETAILS
- FRM COURSE DURATION
- FRM COURSE ELIGIBILITY
- FRM COURSE FEES
- FRM COURSE IN INDIA
- PGP BAT COURSE FEES
- PGP BAT COURSE SALARY IN INDIA
- PGP-BAT COURSE
- PGP-BAT COURSE DETAILS
- PGP-BAT COURSE DURATION
- PGP-BAT COURSE ELIGIBILITY
- PGP-BAT COURSE IN INDIA
- PGP-BAT COURSE INSTITUTE IN INDIA
- PLACEMENTS TO CFA
- US CMA COURSE
- US CMA PREPARATION
- US CPA COURSE
- WHAT IS ACCA COURSE
- WHAT IS CMA COURSE
- WHAT IS FINANCIAL MODELING COURSE
Leave a Reply