How to Remove Duplicates in Excel | How to Find Duplicates in Excel

Abstract: In Excel, there are several ways to filter for unique values or remove duplicate values:

Introduction

Any Duplicate value, text or numbers in the excel is called Duplicates. While working on the Excel sheet with the large numbers of columns, row, items, data, it is hard to find out the duplicates value manually in excel it may cause time consumption. Microsoft Excel’s Duplicate function provide us a better and easy way to find out unique values and remove them permanently.

Purpose

  • To remove duplicate value (Numbers, text etc.) to get accuracy in data.
  • To identify and highlight the duplicates data.

Learning Objects

  1.  How to Highlight Duplicates Value by using Conditional Formatting.
  2.  How to Remove Duplicates value from List.

(A). Procedure to Highlight or Find Duplicates Value

  • Select the List for high lighten the duplicates value.

Procedure to Highlight or Find Duplicates Value

  • Click HomeConditional Formatting > Highlight Cells Rules > Duplicate Values.

Procedure to Highlight or Find Duplicates Value 2

  • A Pop-Up box will appear to pick the formatting to apply on the duplicate values.
  • Click on the drag down option and pick color for cell and then click OK.

Procedure to Highlight or Find Duplicates Value 3

 

Procedure to Highlight or Find Duplicates Value 4

All the Duplicates value will be highlighted as mentioned in above screenshot.


(B). Procedure to Remove Duplicates Value

  • First, select the cells to remove Duplicates value.

Procedure to Remove Duplicates Value

  •  Click DataRemove Duplicates > Continue with the Current Selection > Remove Duplicate>OK.

Procedure to Remove Duplicates Value Step 2

 

Procedure to Remove Duplicates Value Step 3

 

Procedure to Remove Duplicates Value Step 4

  • A Pop-Up will appear indicating the removed numbers and remaining unique values.

Procedure to Remove Duplicates Value Step 5

Duplicate values in your data can be a big problem! It can lead to substantial errors and overestimate your results. So by using above process, the duplicates value will remove permanently.

 

Learning Video for Remove Duplicates in Excel

Join Our Telegram Group techguruplus telegram group Join Our WhatsApp Group techguruplus whatsapp group
Nazim Khan - Author Image

Nazim Khan (Author) 📞 +91 9536250020
[MBA in Finance]

Nazim Khan is an expert in Microsoft Excel. He teaches people how to use it better. He has been doing this for more than ten years. He is running this website (TechGuruPlus.com) and a YouTube channel called "Business Excel" since 2016. He shares useful tips from his own experiences to help others improve their Excel skills and careers.