Excel Formulas to Highlight Unique Values ~ Easy Tricks!!
Tags: excelformula, conditionalformattin, excelformulas
Published: 2021-04-19 06:41:43

---
title: Excel Formulas to Highlight Unique Values ~ Easy Tricks!!
published: true
date: 2021-04-05 08:54:18 UTC
tags: ExcelFormula,Conditionalformattin,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-highlight-unique-values/
---

Sometimes we want to separate the unique values from the table that include duplicate values. How can you quickly achieve them? In this article, we will show the simple formula used to **highlight the unique values in Excel**. Let’s see them below!! 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)

[![Highlight unique values](https://geekexcel.com/wp-content/uploads/2021/04/Highlight-unique-values.png)](https://geekexcel.com/excel-formulas-to-highlight-unique-values/highlight-unique-values/#main)<figcaption id="caption-attachment-22832">Highlight unique values</figcaption>


## General Formula:

- If you want to highlight the unique values from the mixed data you can use the below formula.

**=[COUNTIF](https://geekexcel.com/formulas-to-count-with-countif-function-in-excel-office-365/)(data,A1)=1**

## Syntax Explanations:

- **COUNTIF** – In Excel, this function will help to count the number of cells that meet a single condition or criteria.
- **Data-** It represents the input range.
- **A1** – It represents the input cell.
- **Comma symbol (,)** – It is a separator that helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.

## Practical Example:

Refer to the below example image.

- First, we will enter the input values in **Column B** to **Column E**.
- Here, we are going to highlight the unique names.

[![Input Ranges](https://geekexcel.com/wp-content/uploads/2021/04/Input-Ranges-5.png)](https://geekexcel.com/excel-formulas-to-highlight-unique-values/input-ranges-95/#main)<figcaption id="caption-attachment-22833">Input Ranges</figcaption>

- So, apply the above-given formula to the conditional formatting option.
- To know  **how to apply conditional formatting**  in Excel, just **refer to this article<u>:</u>[ How to Apply the Formula with Conditional Formatting In Excel?](https://geekexcel.com/how-to-apply-formula-with-conditional-formatting/)**
- Finally, it will highlight and display the result as per the below image.

![Result](https://geekexcel.com/wp-content/uploads/2021/04/Result-5.png)<figcaption id="caption-attachment-22834">Result</figcaption>

## Wrap-Up:

Here, we have discussed the simple formula used to **highlight the unique values in Excel**. Let me know if you have any **doubts** regarding this article or any other **Excel/VBA** topic. Thank you so much for visiting our site. To learn more, check out **[Geek Excel](https://geekexcel.com/) **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Read Also:

- **[Excel Formulas to Highlight Intersecting Rows and Columns Exact Match!!](https://geekexcel.com/excel-formulas-to-highlight-intersecting-rows-and-columns-exact-match/)**
- **[Excel Formulas to Highlight Numbers Include Symbols ~ Easy Tutorial!!](https://geekexcel.com/excel-formulas-to-highlight-numbers-include-symbols/)**
- **[Formulas to Highlight the Dates in Same Month and Year!!](https://geekexcel.com/excel-formulas-to-highlight-the-dates-in-same-month-and-year/)**