I tried to use formula to look for duplicate entries in the column A like =if(countif($A$2:A2,A2)>1,"dupe","") or just to count a specific character or value in the column like =countif(B2:B60,"ABC") both of the above don't even work but just showing #NAME?
I use Excel a lot with complex formulas like VLOOKUP, ISERROR, etc... -- View this message in context: http://www.nabble.com/OpenOfice-Calc-can%27t-use-basic-M%24-Excel-formulas-t1391647.html#a3740198 Sent from the openoffice - users forum at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]