Finding unique distinct values from a values in a column.

{=INDEX($A$2:$A$5,MATCH(0,INDEX(COUNTIF($B$1:B2,$A$2:$A$5),0,0),0))}


- this will list down distinct values from the column A(A2:A5) and put them in column B.