Excel formulas to Extract Unique Value From a Column ~ Simple Guide!!
Tags: excelformula, excelformulas
Published: 2020-10-23 08:11:23

---
title: Excel formulas to Extract Unique Value From a Column ~ Simple Guide!!
published: true
date: 2020-10-23 05:44:06 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-extract-unique-value-from-a-column-simple-guide/
---

In this article, we will guide you to learn the simple and useful **Formulas to Extract Unique Value from a Column in Excel Office 365**. Let’s get started!! 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)**
## Formula Syntax:

To [**Extract the Unique Values form a Column in Excel Office**](https://geekexcel.com/how-to-extract-unique-values-from-a-column-with-formula-in-excel/), use the below formula.

**{=[IFERROR](https://geekexcel.com/use-iferror-function-in-microsoft-excel-365-easy-tutorial/)([INDEX](https://geekexcel.com/index-function-in-microsoft-excel-365-how-to-use/)([$A$2](https://geekexcel.com/use-absolute-reference-in-excel-office-365-with-examples/):$A$10,[MATCH](https://geekexcel.com/how-to-use-match-function-in-microsoft-excel-365/)(0,INDEX(COUNTIF($B$1:B1,$A$2;$A$10)+(COUNTIF($A$2:$A$10,$A$2:$A$10)<>1),0,0),0)),””)}**

### Example:

- In the below screenshot, we entered the input in **Column A**.
- Then, apply the given formula.
- After entering the formula it will display the output in **Column**  **B** as shown below.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/07/op13.png)

## Syntax Explanations:

- **IFERROR** – This function will return the custom results when the formula generates an error otherwise it displays the standard results. Read more on the **[IFERROR Function](https://geekexcel.com/use-iferror-function-in-microsoft-excel-365-easy-tutorial/)**.
- **INDEX** – In Excel, the [**INDEX Function**](https://geekexcel.com/index-function-in-microsoft-excel-365-how-to-use/) will return the value at the given position in a range or array.
- **MATCH** -This function will locate the position of a lookup value in a row, column, or table. Read more on the [**MATCH Function**](https://geekexcel.com/how-to-use-match-function-in-microsoft-excel-365/).
- **Absolute Reference ($)** – The [**Absolute Reference ($)**](https://geekexcel.com/use-absolute-reference-in-excel-office-365-with-examples/)is an actual fixed location in a worksheet. It won’t be changed any values from a row or column when it is copied.
- **COUNTIF** – The main purpose of the Excel  **COUNTIF Function** is to count the cell that matches a single condition or criteria.
- **Plus Operator (+)** – This symbol is will add the values.
- **Comma (,)** – It is a separator which helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.

## Bottom Line:

In this short tutorial, we explained the details of the **formulas to extract the unique value from a column in Excel** with its basic syntax and explanations. If you have any **doubts/suggestions,** kindly drop it in the below comment section. Thank you so much for Visiting Our Site!! Continue learning on **[Geek Excel](https://geekexcel.com/)!! **