Hi Melvyn,

Use below forumla in column C and drag it down:-

=IF(ISNUMBER(MATCH($B2,A:A,0)),"","x")

Regards,
DILIPandey

<click on below 'star' if this helps>