I have two excel sheets both having lakhs (hundreds of thousands) of records. I want to compare if the records present in file1 is also present in file2 or not. Also I want to check what all are the different records which are present in file1 and are not in file2.
I think this answers your questions if they are similar sheets:
If it doesn't solve, could you please clarify exactly how the data is ordered/organized in those sheets?