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
Formula Syntax:
To Extract the Unique Values form a Column in Excel Office, use the below formula.
{=IFERROR(INDEX($A$2:$A$10,MATCH(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.
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.
- INDEX – In Excel, the INDEX Function 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.
- Absolute Reference ($) – The Absolute Reference ($)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!! *
Top comments (0)