Compare 2 excel documents and find the same data in both sheets [Closed]

Question

Compare 2 excel documents and find the same data in both sheets [Closed]

Report

ULAB2017 - Jan 4, 2017 at 12:38 PM
xpcman

Posts: 19540
Registration date: Wednesday October 8, 2008
Status: Contributor
Last seen: June 15, 2019

- Jan 4, 2017 at 04:36 PM

Hi
I have 2 separate excel documents, 1 which had 2015/2016 data and the second which has 2014 data. What i need is to compare the 2 documents for matching job numbers - so each line relates to a job number, but as there are 1000s of lines in each document i need something that will enable me to quickly compare and look for the job numbers in the 2015/16 file and find which ones are also in the 2014 file and then i want only those lines to be copied across to the 2015/16 file?

Is this possible?

Compare 2 excel documents and find the same data in both sheets
Compare 2 excel sheets and highlight differences ✓ - Forum - Excel
How to compare two Excel sheets with varying data ✓ - Forum - Excel
Compare 2 excel worksheets and remove duplicates - Forum - Excel
Excel - Comparing 2 columns and removing duplicates - How-To - Excel
A variation on the compare 2 columns in Excel ✓ - Forum - Excel

1 reply

Ask a question

xpcman · Answer 1 · 2017-01-04T16:36:31-0500

Answer 1 / 1

xpcman

Posts: 19540
Registration date: Wednesday October 8, 2008
Status: Contributor
Last seen: June 15, 2019

1,677
Jan 4, 2017 at 04:36 PM

I suggest you read this:

https://ccm.net/forum/affich-472736-comparing-data-between-two-excel-sheets

Compare 2 excel documents and find the same data in both sheets [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!