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