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