Previous Topic Next Topic

Differences in two excel sheets

Closed
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?

Similar discussions

Comparing Two Excel Sheets and copying like data to third sheet
coz2992 -
TrowaD -

11 responses
How to compare two Excel sheets with varying data
BWIRyan -
TrowaD -

15 responses
macro to compare two excel sheets
annajins -
Aks -

6 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses