How To Find Duplicate Data In Ms Excel?

 You can find duplicate data in Microsoft Excel using several built-in methods. Here are the most common and effective ways as blow:

 **Method 1: Use Conditional Formatting**

1. **Select the range** where you want to check for duplicates (e.g., a column or entire table).
2. Go to the **Home** tab.
3. Click on **Conditional Formatting** → **Highlight Cells Rules** → **Duplicate Values**.

4. In the dialog box:

   * Choose how you want to highlight the duplicates (e.g., with a red fill).
   * Click **OK**.

 This will highlight all the duplicate values in the selected range.



**Method 2: Use the `COUNTIF` Formula**

If you want to **flag or filter duplicates** more precisely:

1. In a new column, enter the formula:

    =IF(COUNTIF(A:A, A2)>1, "Duplicate", "Unique")
   
   Replace `A:A` with your column and `A2` with the first cell of the data you’re checking.

2. Copy the formula down to apply it to all rows.

 This will mark each row as “Duplicate” or “Unique”.

 **Method 3: Remove Duplicates (for cleanup)**

1. Select your data range.
2. Go to the **Data** tab.
3. Click on **Remove Duplicates**.
4. Choose which columns to check for duplicates.
5. Click **OK**.

 This will delete all but one occurrence of each duplicate.



Optional: Use Pivot Tables or Power Query

If you're working with larger datasets or need more control:

* **Pivot Tables**: Summarize and count occurrences.
* **Power Query**: Load data into Power Query, group and count, or filter duplicates.



Let me know your exact goal (e.g., just highlighting, deleting, or analyzing duplicates), and I can tailor the steps better!