=INDEX($A$1:$A$10,MATCH(0,COUNTIF($B$4:B4,$A$1:$A$10),0))
me formula eken puluwan unique values extract karanna. meka Vector formula ekak. liyala ivara unava CTRL+SHIFT+ ENTER press karanna one.
uda formula eke formula eka liyala thiyenna cell B5 vala.
$A$1:$A$10 - range with duplicate values...