Re: [libreoffice-users] Calc Question

Hi Chris,

Chris Gummo schrieb:
> This formula "=COUNTIF($F$4:$K$380;F4)=1" is actually used in the Data
> Validation section in Excel and looks through cells F4 through K380 and does
> not allow us to input multiple serial numbers for equipment. For instance,
> we scan a serial number in cell F4 and try to scan the same number in cell
> F8 then we will get an error message saying that we already scanned that
> serial number in. I tried to do the same thing in Calc but it does not allow
> me to make a custom criteria under DATA>VALIDITY. As for the "=1" at the end
> I am not sure why it is there. I have been going with the status quo under i
> was task to find an alternative to MS Office. Lucky me I guess.

Is it necessary to prevent entering? If you only want to be informed 
about double entries, you can use conditional formatting. For example 
set a red background if "=COUNTIF($F$4:$K$380;F4)>1" is true.

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