I suggest going to the help section and entering "data validity" in the
search box.  This worked for me in OpenOffice.org.

nvsoar

On Mon, Apr 11, 2011 at 12:18 PM, Chris Gummo <ch...@reclamere.com> wrote:

> This formula "=COUNTIF($F$4:$K$380;F4)=1" is actually used in the Data
> Validation section in Excel and looks through cells F4 through K380 and
> does
> not allow us to input multiple serial numbers for equipment. For instance,
> we scan a serial number in cell F4 and try to scan the same number in cell
> F8 then we will get an error message saying that we already scanned that
> serial number in. I tried to do the same thing in Calc but it does not
> allow
> me to make a custom criteria under DATA>VALIDITY. As for the "=1" at the
> end
> I am not sure why it is there. I have been going with the status quo under
> i
> was task to find an alternative to MS Office. Lucky me I guess.
>
> Chris
>
> On Mon, Apr 11, 2011 at 2:49 PM, Steve Edmonds
> <steve.edmo...@ptglobal.com>wrote:
>
> > It seems like a few others here I tried your formula.
> > the =1 at the end of  =COUNTIF(F4;K380,F4)=1 makes it a TRUE/FALSE
> > evaluation.
> > I tried to use this as validation for input but it didn't seem to work
> > without considering a macro.
> >
> > Could you please explain how this formula is used.
> > i.e. I assume data is input into cells F4 to K380.  What cell number is
> > this formula in?
> > Cheers,steve
> >
> >
> > On 12/04/11 04:50, Chris Gummo wrote:
> > > I have tried the formula below with the $ signs and I only get a TRUE
> or
> > > FALSE answer when I type this into the cell. Maybe I am doing something
> > > wrong which is a very good possibility. We have been using this code
> > since
> > > before I started working here and I am not too strong with formulas
> like
> > > this. I can do the easy ones with no problem. Could you let me know how
> > you
> > > did it since it worked for you?
> > >
> > > On Sun, Apr 10, 2011 at 6:11 PM, Roger T. Imai <roger.t.i...@gmail.com
> > >wrote:
> > >
> > >
> > >> Aha! It WAS the separator. Regina's answer to Chris Gummo is helpful
> > >> to me also. Thank you.
> > >>
> > >>
> > >>
> > >> On Sun, Apr 10, 2011 at 4:40 PM, Regina Henschel
> > >> <rb.hensc...@t-online.de> wrote:
> > >>
> > >>> Hi Chris,
> > >>>
> > >>> Chris Gummo schrieb:
> > >>>
> > >>>> 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
> > >>>>
> > >>> Please have a look at the separators. I guess it should be
> > >>> =COUNTIF(F4:K380;F4)=1
> > >>>
> > >>> If you want to copy&paste the format, then I expect
> > >>> =COUNTIF($F$4:$K$380;F4)=1
> > >>>
> > >>> Kind regards
> > >>> Regina
> > >>>
> > >>> --
> > >>> 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
> > >>
> > >>
> > >
> > >
> > >
> >
> > --
> > 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
>
>

-- 
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

Reply via email to