On Fri, 2009-02-27 at 22:26 +0100, axel.stamm...@student.hu-berlin.de wrote: > -----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.
Try entering these formulae as array formulae (ctrl-shift-enter). Andreas > -- Andreas J. Guelzow <aguel...@pyrshep.ca> _______________________________________________ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list