Quickly Extract Unique Values Including First Duplicate From An Excel Column

There may be a formula that can help you to extract unique values including the first duplicate values from a column in Excel, but it may be difficult to remember. With Kutools for Excel installed, you can apply the Extract cells with unique values (include the first duplicate value) feature to handle this job in Excel.