Formulas to Extract Unique Values Including First Duplicate From An Excel Column:
In this tutorial, we explain the formulas to Extract Unique Values Including First Duplicate From an Excel Column. Get an official version of MS Excel from the following link: https://www.microsoft.com/en-in/microsoft-365/excel
Formula Syntax:
- For extracting the unique values including the first duplicate from an Excel column, use the below formula.
{=IFERROR(INDEX($A$2:$A$10,MATCH(0,COUNTIF($C$1:C1,$A$2:$10),0)),” “)}
Example:
- In the below screenshot, the input products are shown in Column A.
- Then enter the given formula as shown in the image to get unique values as output.
- After applying the formula, it will display the result in the selected Column C as shown below.
Explanations for Syntax:
- IFERROR – This function will display the custom result when the formula generates an error otherwise it will show the standard result. Read more on the IFERROR Function.
- INDEX – The Excel INDEX Function is used to get a value in a list or table based on the location. Read more on the INDEX Function.
- *MATCH * – In Excel, the main purpose of the MATCH Function is to locate the position of a lookup value in a row, column, or table. For more details on MATCH Function.
- COUNTIF – The COUNTIF Function count the cells in a range that matches a single condition or criteria and this function performs the partial matching in logical operations and Wildcards.
Conclusion:
From this article, you can get the clarification about the Formulas to Extract a Unique Values in a First Duplicate from an Excel Column. Kindly drop your feedback in the comment section. Thank you for visiting Geek Excel!!
Top comments (0)