plino wrote: > Even with the array working it's not detecting non-numeric cells properly. > Can you upload your spreadsheet somewhere so I can see what I'm doing wrong?
Hi plino, sure, the upload link is: http://www.2shared.com/file/WuzUYsyS/FindNonNumeric.html See the formula in cell C2. Let me know whether or not you succeed. Regards Jack -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.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