Quote Originally Posted by syedfahadjalali View Post
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.