How can I count (from the left) the number of blank cells before the first non-blank cell?
- From: axel stammler student hu-berlin de
- To: Mailing list <gnumeric-list gnome org>
- Subject: How can I count (from the left) the number of blank cells before the first non-blank cell?
- Date: Fri, 27 Feb 2009 22:26:53 +0100 (CET)
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi,
I work in teaching and need this simple straightforward function. Despoite its simnplicity
I have been looking in vain for a solution as the search terms are much too general. The
manuals &c. mention lots of highly complex functions but none that could help me here.
result col 1 col 2 col 3 col 4 col 5
2 11 7 8
1 13 12 11 10
4 11 12
A couple of years agon I found that MATCH provided a way, possibly in combination with IF:
=match(FALSE,if(H4:DZ4=""),0)
Obviously this should work, too:
=match(FALSE,isblank(H4:DZ4),0)
The first formula worked before the Debian upgrade from Etch to Lenny, i.e. to version
"1.8.3-5+lenny1", about a week ago; now it only returns "#N/A!", just like the second
ones.
Any help would be much appreciated.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)
Comment: Made with pgp4pine 1.76
iEYEARECAAYFAkmoWqQACgkQcK38PJiB3dTwRACgw0lzRdEMruwxDZkzAfR/SLLt
W5cAn3e2PJnMo8SEeyrZWMmLq4pYThJY
=yNJ0
-----END PGP SIGNATURE-----
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]