Re: How do I compare the contents of two Excel 2004 files?

by JE McGimpsey <jemcgimpsey@[EMAIL PROTECTED] > Oct 4, 2008 at 04:27 AM

In article <59b5b6f9.-1@[EMAIL PROTECTED]
>,
 Shawn_Logan@[EMAIL PROTECTED]
 wrote:

> Version: 2004
> Operating System: Mac OS X 10.4 (Tiger)
> Processor: Power PC
> 
> I am trying to determine the differences in two similar Excel
spreasheets. Is 
> there a means to do this?

One way:

Create a third sheet. Enter in A1:

   =IF(Sheet1!A1=Sheet2!A1,"","Different")

Copy A1 down and across as far as necessary.