----- Original Message ----- From: "Lovell Mcilwain" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Thursday, July 07, 2005 11:13 AM Subject: [users] Calc Cell Comparison?
> 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 > In OOo1.1.4, you can compare text using formulas (in cells elsewhere in your spreadsheets), something along this line: =(EXACT(Sheet1.B3;Sheet2.C3)) In this example, you are comparing the contents (text) of cell B3 on Sheet1 with cell C3 on sheet 2. Note that the =Exact function is case sensitive. There are other string functions that may also be helpful; see Insert > Function List, then select TEXT. Automate the comparison? Probably with a macro that scans down the list of cells to be compared; but I have trouble visualizing what your spreadsheet looks like. If you can send a SMALL sample sheet to me (off line from the User list) I'd look at doing something, but there are NO guarantees (I'm still trying to learn to write my own macros!). -- John Viestenz
