A 1 and B 1 columns.

Then c 1 = exact (a 1, b 1), and compare two columns at the same time. The data can only be used in the same row. If it is less than the same row, it will be more troublesome. Another formula can be used to compare whether column B has these data in column A, and the formula c 1 = if (countif ($)).

Explain that $A$ 1:$A$200 is an interval. . You can modify it yourself. .

If it is c1= if (countif ($ a $1:$ a $200, b 1) > = 1, "Yes", "None")

You can return duplicate values. . Of course, it's best not to repeat it, or it will be more troublesome ~