I believe the expresion is a boolean expresion where you compare if the
COUNTIF(F4;K380,F4) is equal to 1.
It means that if the count of cells in the range F4:K380 having the
value matching the contents of F4 is 1 (only 1 such a cell) let the
result is true.
There is a typo in the syntax; it should be =COUNTIF(F4:K380;F4)=1
Regards,
Jiri
Dne 11.4.2011 18:01, Johnny Rosenberg napsal(a):
sön 2011-04-10 klockan 16:52 -0400 skrev Chris Gummo:
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
Thanks
Chris
Sorry for being some kind of an idiot, but what does the ”=1” mean at
the end of the formula?
--
OBUTEX spol. s r.o.
Ing. Jiří Hladůvka
Zlatovská 22
911 05 Trenčín
EU Slovakia
--
mailto:[email protected]
http://www.obutex.com
--
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
