You can use Excel Feature Quick Analysis, no formula needed.
Select both the columns for which you need to compare data
Right click and choose Quick Analysis
from this option choose Unique Values
This highlights row cells data which is missing from one column
enter image description here Output result from Quick Analysis