Excel - Duplicate Data 1

[Acowaz]

I need help in trying to figure out how to merge two excel sheets. I have two databases both are exactly the same. One is in excel & once you copy the second database into excel. I want it to tell me which entry is duplicate or slightly different? Or even just eliminate that duplicate automatically. Thanks in advance!

Aco

 

[Acowaz]

I forgot to mention spreadsheet two is slightly different. With very few variations from spreadsheet. thanks again

Aco

 

[VBOnly]

One cross-software solution using Word compare document feature, not very neat. Select and copy the first workbook to word and save in Word. Select and copy the second to Word. In the 2nd Word document, run menu "Tool"-"Compare Document" to compare to the first Word file. The resultant document will high-light the differences.

Another not-so neat solution in Excel. Put two worksheets in one workbook and add a third worksheet, on the 3rd sheet, in A1 type formula:
=IF(Sheet2!A1=Sheet1!A1,"","Different&quot
Then copy A1 to all cells. You will see the word "Different" at non-same cells.

 

[Acowaz]

Thanks VBONLY. I like those both methods.