Yes it can - you just need to understand the differences between OOo and Excel.
First off, OOo uses ";" to separate function components. Your formula should therefore be : =if(countif($A$2:A2;A2)>1;"dupe";"") Same with the other formula. Have a look at documentation.openoffice.org for tutorials on calc. Even better to read these before posting questions... /paul On 4/4/06, JimboL <[EMAIL PROTECTED]> wrote: > > 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] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]