Array 2: Formula to pull UNIQUE values from Duplicates
Try this instead:
IFERROR(INDEX($A$2:$A$23, SMALL(IFERROR(1/(MATCH(A$2:A$23, A$2:A$23, 0) = (ROW(A$2:A$23)-1))*ROW(A$2:A$23), 2^32)-1, ROWS(C$2:C2))), "")
How to pull uniques from a list using an Array Formula
Here is the simpler, non array method: • Pull Uniques from List of Duplicates