Formula help on distinct value

[Tkr567]

Hi everyone

Looking for some help on a formula which will return the first unique value in a range.

Included an image of what I'd like the formula to return - basically if the value in column A has appeared for the first time, then column B should return the value in column A. However, if that value then repeats, the formula should return a blank.

Just can't get my head round how to do this

 

[Fluff]

How about

=IF(COUNTIFS(A$2:A2,A2)=1,A2,"")

 

[mikerickson]

=IF(MATCH(A2,A:A,0)=ROW(A2), A2, "")

 

[Tkr567]

How about

=IF(COUNTIFS(A$2:A2,A2)=1,A2,"")

That's got it - thank you!

 

[Fluff]

Glad we could help & thanks for the feedback.