2011 Archives by date, by thread · List index

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