Hello All! I am somewhat new to Excel and I am stumped with a current task.

I have 2 separate excel files. Each has 200,000 records.

How do "compare, remove duplicates, scrub" so that I can discover the number of total unique records in File 2 vs File 1.

Hope I was clear enough. Any assistance would be greatly appreciated.

Thanks in advance for your help!