Differences in two excel sheets [Closed]

Report

Dani - Feb 15, 2016 at 10:49 PM

Hello,

I am trying to see if I can compare the first column in two different excel sheets to see if there are differences.

Column A Book 1 Column A Book 2

Z3YOAA Z3YOAA
AZQOAA AZQOAA
WB2PAA HLUPAA
FHFOAA FHFOAA

As you can see the third one down in book 2 is different. How can I run a Look up to quickly identify if there are differences? And do both sheets have to to be in exactly the same order for it to work?

Differences in two excel sheets
Highlight differences between two excel sheets ✓ - Forum - Excel
Compare differences between two excel sheets ✓ - Forum - Excel
Compare two excel sheets and highlight differences macro ✓ - Forum - Excel
Comparing Two Excel Sheets and copying like data to third sheet ✓ - Forum - Excel
Comparing two excel worksheets ✓ - Forum - Excel

Your reply