Blog 01 - Find Duplicates in seconds

How to Find Duplicates in Excel (Step-by-Step)

Method 1: Using Conditional Formatting (Easiest Way)

1. Open your file in Microsoft Excel
2. Select the data range where you want to check duplicates
3. Go to the Home tab on the top menu
4. Click on Conditional Formatting
5. Choose Highlight Cells Rules → Duplicate Values
6. Select a highlight color (e.g., red or green)
7. Click OK

👉 Excel will instantly highlight all duplicate values in the selected range.

Method 2: Using Remove Duplicates Tool

1. Select your dataset
2. Go to the Data tab
3. Click on Remove Duplicates
4. Choose the columns you want to check
5. Click OK

👉 Excel will remove duplicate values and keep only unique entries.

Method 3: Using Formula (Advanced Method)

1. Assume your data is in column A
2. In a new column, enter this formula:

=COUNTIF(A:A, A1) > 1

1. Press Enter and drag down

👉 If the result is TRUE, the value is a duplicate.

Why This Is Useful

Finding duplicates helps you:

• Clean and organize your data
• Avoid errors in reports
• Maintain accurate records

This method works for lists like names, phone numbers, emails, or any repeated data in Excel.