Countif using 2 sheets

Hi Novice22

How about!

If your data is in A1:A4 in B1:

Formula:

=IF(COUNTIF($A$1:A1,A1)=1,"Yes","No")

and drag down.