Find Duplicate or Unique Cells/Rows in a Range in Excel 365!!
Tags: kutoolsexceltutorial, stepstofindduplicate, kutools
Published: 2020-10-12 12:03:54

---
title: Find Duplicate or Unique Cells/Rows in a Range in Excel 365!!
published: true
date: 2020-10-12 11:11:05 UTC
tags: KutoolsExcelTutorial,StepstoFindDuplicate,Kutools
canonical_url: https://geekexcel.com/find-duplicate-or-unique-cells-rows-in-a-range-in-excel-365/
---

In this article, we will explore how to **Find Duplicate or Unique Cells/Rows in a Range in Excel Office 365** using **Kutools. ** Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## Find and Highlight Duplicate Rows in a Range:

If you want to find and highlight duplicate rows in a range, do the below steps.

- You need to select the range where you want to find the duplicate rows.

![Example data range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Example-data-range-1.png)<figcaption id="caption-attachment-15610">Example data range</figcaption>

- On the **Kutools Tab, click** the **Select** option, **choose** the **Select**  **Duplicate & Unique Cells** option.

![Choose the Select Duplicate & Unique Values option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Choose-the-Select-Duplicate-Unique-Values-option.png)<figcaption id="caption-attachment-15611">Choose the Select Duplicate &amp; Unique Values option</figcaption>

- It will open the **Select Duplicate & Unique Cells dialog box**.
- In the **Rule section,** you need to **choose** **Duplicates (Except 1st one)** or **All duplicates (Including 1st one)** option as you wish.
- You can also **select** the **background color** or **font color** to highlight the duplicate rows.
- **Click** the **OK** button.

![Select Duplicate & Unique Cells Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Select-Duplicate-Unique-Cells-Dialog-Boxe.png)<figcaption id="caption-attachment-15612">Select Duplicate &amp; Unique Cells Dialog Box</figcaption>

- After clicking the OK button, a prompt box will pop out to tell you how many rows have been highlighted.

![Prompt Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Prompt-Box-3.png)<figcaption id="caption-attachment-15613">Prompt Box</figcaption>

- Now, the duplicate rows have been selected as below screenshot.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Result-11.png)<figcaption id="caption-attachment-15614">Result</figcaption>

## Find and Highlight Unique Rows in a Range:

You can also find and highlight unique rows from the selected range, follow the below instructions.

- You need to select the range where you want to find the unique rows.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/1-15.png)<figcaption id="caption-attachment-15615">Example</figcaption>

- On the **Kutools Tab, click** the **Select** option, **choose** the **Select**  **Duplicate & Unique Cells** option.

![Choose the Select Duplicate & Unique Values option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Choose-the-Select-Duplicate-Unique-Values-option.png)<figcaption id="caption-attachment-15611">Choose the Select Duplicate &amp; Unique Values option</figcaption>

- It will open the **Select Duplicate & Unique Cells dialog box**.
- In that dialog box, **select** the **Unique values only** or **All unique** **(Including 1st duplicates)** under the **Rule** section.
- You can also **specify the background color or font color** to highlight the unique rows.
- Finally, **click** the **OK** button to get the result.

![Select Duplicate & Unique Cells Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/2-12.png)<figcaption id="caption-attachment-15616">Select Duplicate &amp; Unique Cells Dialog Box</figcaption>

- After clicking the **OK button** , a prompt box will pop out to tell you how many unique rows have been highlighted.

![Prompt Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/3-10.png)<figcaption id="caption-attachment-15617">Prompt Box</figcaption>

- Now, you can see the result as shown in the below image.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/4-5.png)<figcaption id="caption-attachment-15618">Result</figcaption>

## Highlight Duplicate or Unique Cells in One Column:

To **highlight duplicate or unique** cells in one column, follow the below steps.

- You need to select the column from which you want to highlight the duplicate values.

![Sample data](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/5-5.png)<figcaption id="caption-attachment-15619">Sample data</figcaption>

- Go to the **Kutools Tab, click** the **Select** option, **choose** the **Select**  **Duplicate & Unique Cells** option.

![Choose the Select Duplicate & Unique Values option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Choose-the-Select-Duplicate-Unique-Values-option.png)<figcaption id="caption-attachment-15611">Choose the Select Duplicate &amp; Unique Values option</figcaption>

- It will open the **Select Duplicate & Unique Cells dialog box**.
- You need to **check**  **any option** under the **Rule** section as you need.
- Next, you need to **check the Fill backcolor** or **Fill font color** option and specify them using the below drop-down list.
- Now, **hit** the **OK** button.

![Select Duplicate & Unique Cells dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/6-3.png)<figcaption id="caption-attachment-15620">Select Duplicate &amp; Unique Cells dialog box</figcaption>

- After clicking the **OK button** , a prompt box will pop out to tell you how many duplicate values have been highlighted.

![Prompt Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/7-2.png)<figcaption id="caption-attachment-15621">Prompt Box</figcaption>

- It will highlight the duplicate values in the specified column as shown in the below screenshot.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/8-2.png)<figcaption id="caption-attachment-15622">Output</figcaption>

## Conclusion:

In this article, you can clearly understand the steps to **Find Duplicate or Unique Cells/Rows in a Range in Excel Office 365** using **Kutools** with the example screenshots. Leave your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### Read Ahead:

- [Clear All Formatting of a Range in Excel](https://geekexcel.com/how-to-clear-all-formatting-of-a-range-in-excel-office-365/)
- [Insert Multiple Checkboxes at Once](https://geekexcel.com/insert-multiple-checkboxes-at-once-in-excel-office-365/)