Identify and extract duplicate values from a single column using COUNTIF and IF formulas.
Extract unique duplicate words from a single text string using dynamic array functions in Excel.