Hi Lovell,
Add a new sheet to the file you want to compare. Assuming
that the data you want to compare are in Sheet1 and Sheet2,
in cell A1 of the new sheet enter the formula below:
=Sheet1.A1=Sheet2.A1
Copy the formula in A1, select an area in the same sheet
equal to the used area in the sheets you want to compare and
paste. Search for 'False'.
tc
p.s.
If you want to see the differences, you could get a little
fancier and use:
=IF(Sheet1.A1=Sheet2.A1;"";Sheet1.A1&"<>"&Sheet2.A1)
That way, matching cells result in empty cells, differences
are displayed.
Lovell Mcilwain wrote:
Hello all,
Is there a way in OO Calc to compare cells on one sheet to cells on
another sheet? I'm only talking about a simple text comparison nothing
more. I would like to verify some accounts in two different places and
its ALOT of them so if I can automate it some how that would make things
work a lot better for me.
Thanks in advance
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
