how to find the common data from two excel files

Copper Contributor

Hi

I just want to know how to find the common data from two excel files 

and thank you

 

1 Reply

@reem369 

Depending on how much detail you're looking for, the solution may be as simple as a lookup formula or for a lot more detail something like Inquire's Compare Files feature.

 

Compare workbooks using Spreadsheet Inquire (microsoft.com)