Re: [users] OpenOfice Calc can't use basic M$ Excel formulas

[Daniel Rentz]

JimboL schrieb:

I tried to use formula to look for duplicate entries in the column A like

=if(countif($A$2:A2,A2)>1,"dupe","")

                    ^^^   ^^^    ^^^
Calc always uses semicolons.


Regards
Daniel

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]