Re: [libreoffice-users] Calc Question

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



-- 
Thank You,


Christopher Gummo
Technician
Reclamere Inc.
(814) 684-5505 ext 312
Certified Data Destruction Services
Data Recovery Services
Hard Drive e-Discovery Services

The information contained herein is intended for the confidential use of the
recipient named above. This message may be a client communication and as
such is privileged and confidential. If the reader of this message is not
the intended recipient you are hereby notified that you have received this
document in error and that any review, dissemination, distribution or
copying of this message is strictly prohibited. If you received this message
in error please notify the sender and destroy this message. Thank you.

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