Comparing 2 different workbooks help

[falcios]

I am using this formula to compare 2 workbooks
=IF('[WB1.xls]703'!A1<>'[WB2.xls]703'!A1,"Different","")

It returns different in certain cells but it doesn't tell me exactly where they are. For example line 19 on one spreadsheet shows different but the other spreadsheet does not have a line 19.

Any suggestions on why it is not working or a better formula.

Thanks.

 

[Fazza]

Hi, falcios.

It might be better to post a small sample of data from each workbook?

Regards, Fazza