how to find the common data from two excel files

%3CLINGO-SUB%20id%3D%22lingo-sub-3401072%22%20slang%3D%22en-US%22%3Ehow%20to%20find%20the%20common%20data%20from%20two%20excel%20files%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3401072%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3EI%20just%20want%20to%20know%20how%20to%20find%20the%20common%20data%20from%20two%20excel%20files%26nbsp%3B%3C%2FP%3E%3CP%3Eand%20thank%20you%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3401072%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3401176%22%20slang%3D%22en-US%22%3ERe%3A%20how%20to%20find%20the%20common%20data%20from%20two%20excel%20files%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3401176%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1394877%22%20target%3D%22_blank%22%3E%40reem369%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDepending%20on%20how%20much%20detail%20you're%20looking%20for%2C%20the%20solution%20may%20be%20as%20simple%20as%20a%20lookup%20formula%20or%20for%20a%20lot%20more%20detail%20something%20like%20Inquire's%20Compare%20Files%20feature.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fcompare-workbooks-using-spreadsheet-inquire-ebaf3d62-2af5-4cb1-af7d-e958cc5fad42%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ECompare%20workbooks%20using%20Spreadsheet%20Inquire%20(microsoft.com)%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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)