How to compare two columns and find missing data in Excel

hello @rohith.prabhu Thanks for your solution. I have got the mismatched data. Actually I want to find the data that is present on the colum1 and not present on the column2. Like the following example:
image
Is it possible to extract that kind of data? If there is any solution for the workflow, please share with me. Best regards.