Tried this - but couldn't get it to work - using sheets in one workbook.
However - we will be working on identical sheets in 2 separate workbooks. So
how do we check to assure that the workbooks are identical?
In the meantime, I will play with your formula again. And thank you for
your assistance.

"Svea" wrote:


One of the simple ways is surely this one:

On the third sheeet write down a formula:
=EXACT(Sheet1!A1;Sheet2!A1)
then copy it through cells in same range as it is in identical sheets.

If it is OJ, formula will return TRUE, if it is not you will get
FALSE.

hope it will help you.


--
Svea
------------------------------------------------------------------------
Svea's Profile: http://www.excelforum.com/member.php...o&userid=28151
View this thread: http://www.excelforum.com/showthread...hreadid=477625