Extract unique items from a list in Excel

Array distinct formula (requires pressing Ctrl + Shift + Enter):

{=INDEX(list,MATCH(0,COUNTIF($D$4:D4,list),0))}

=IFERROR(INDEX($A$2:$A$10, MATCH(0, COUNTIF($B$1:B1, $A$2:$A$10), 0)), "")

References
https://exceljet.net/formula/extract-unique-items-from-a-list