Re: [libreoffice-users] Calc Question

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.imai@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.henschel@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+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