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
