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 <[email protected]> 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 > <[email protected]>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 [email protected] >> 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 [email protected] > 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 [email protected] 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
