-----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----- _______________________________________________ gnumeric-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnumeric-list
