Yes, it is possible.......however, I personally use a commercial Add-in from
Jim Cone called XL Companion to make such comparisons. It does a super job
of detailing all the differences.

Vaya con Dios,
Chuck, CABGx3



"AMXAH" wrote:

Have two different workbooks with company names in columns and looking to
build a formula or macro that will compare each column in each workbook and
return differences.