Ignore duplicates in list

Originally Posted by Fotis1991

ARRAY formula.

Formula:

=INDEX($A$2:$A$20, MATCH(0, IF(ISBLANK($A$2:$A$20), 1, COUNTIF(B1:$B$1, $A$2:$A$20)), 0))

In B2 and copy down.



-- Array(CSE) { }, formulae are confirmed with Control+Shift+Enter.
Not just Enter.

Thank you, thats what I was looking for - don;t want to push my luck but is the same result possible without the Array?