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.knu...@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+h...@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+h...@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