How to compare two columns and find out the missing elements in one with respect to other

Nothing was in your exel file. only two same columns in two sheets with same values

Originally Posted by syedfahadjalali

Nothing was in your exel file. only two same columns in two sheets with same values

I found this as already solved. But let me give clarification on your query on the Excel file attached. Sheet1 is in Advanced Filter mode. Please remove filter (Data -> Filter ->Click Filter to remove). You will see more items in Sheet1 than Sheet2. Then try to recreate the advanced filter using the steps provided.