Re: [libreoffice-users] Calc Question

Chris,

More information please: in LibreOffice Calc, Tools > Options >
LibreOffice Calc > Formula ...have you changed Formula Syntax from the
default Calc A1 to Excel A1 (or perhaps Excel R1C1 for references to
other worksheets)?

I'm no spreadsheet expert, but I've found that most of my formula
problems using XLS files in OpenOffice/LibreOffice have turned out to
be with the separators in the formulas. I had been changing the
separators in my Excel worksheets, and only very recently discovered
that I could actually choose the formula syntax to match Excel's.

Here is Excel information on COUNTIF, btw.
http://office.microsoft.com/en-us/excel-help/countif-HP005209029.aspx

--Roger


On Sun, Apr 10, 2011 at 3:52 PM, Chris Gummo <chris@reclamere.com> wrote:
> The formula that we use is below. We use it in the Data Vailidation section
> and not in every cell. I have not been able to get it to work.
>
> =COUNTIF(F4;K380,F4)=1
>
> Thanks
> Chris
>
>
>
> On Fri, Apr 8, 2011 at 4:29 PM, Johnny Rosenberg <gurus.knugum@gmail.com>wrote:
>
> > fre 2011-04-08 klockan 15:15 -0400 skrev Chris Gummo:
> > > My company is in the process of moving to LibreOffice from MS Office. We
> > do
> > > inventory of equipment from our customers and in Excel we have a formula
> > > that does not allow us to scan in duplicate serial numbers. Does any one
> > > know of a way to do this using Calc in LibreOffice?
> > >
> > > Chris
> >
> > I guess that could be done in several ways. What does that formula look
> > like in Excel?
> >
> > --
> > Best regards
> >
> > Johnny Rosenberg
> >
> >
> > --
> > Unsubscribe instructions: E-mail to users+help@libreoffice.org
> > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> > List archive: http://listarchives.libreoffice.org/www/users/
> > All messages sent to this list will be publicly archived and cannot be
> > deleted
>
> --
> Unsubscribe instructions: E-mail to users+help@libreoffice.org
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/www/users/
> All messages sent to this list will be publicly archived and cannot be deleted

-- 
Unsubscribe instructions: E-mail to users+help@libreoffice.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/www/users/
All messages sent to this list will be publicly archived and cannot be deleted