On 05/07/12 05:22, dave_ wrote:
Thanks to both Simon and Miguel for their solution (they both works).
One more question and this problem is solved for good.
I notice I give a range larger than the actual data (rows) needed.
How can I limit the range based on the last row that has data?
This will give me an actual count of blanks cells within the rows being
added.
Again, thanks for the help or should I say "for the support".
--
View this message in context:
http://nabble.documentfoundation.org/CALC-How-to-count-blank-cells-tp3993572p3993714.html
Sent from the Users mailing list archive at Nabble.com.
It is a bit unclear what you are trying to do. It appears you are trying
to establish the number of rows with data in them for some sort of
import/reiteration routine.
Maybe what you should be doing is counting how many values in your range
using COUNTA(), DCOUNT() or DCOUNTA() rather than looking for the number
of blanks, the last cell used and presumably the difference between
these two values.
--
Cheers Simon
Simon Cropper - Open Content Creator
Free and Open Source Software Workflow Guides
------------------------------------------------------------
Introduction http://www.fossworkflowguides.com
GIS Packages http://www.fossworkflowguides.com/gis
bash / Python http://www.fossworkflowguides.com/scripting
--
For unsubscribe instructions e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
