Countif not as aggregate column

Is there a way I can achieve something similar as =(COUNTIF($B$1:$B1,$B1)=1)+0 as a formula column in my table?

Where B is the column which contains the values, so it puts a '1' in the first record found and '0' in the others.

Thanks