Hi Axel,
I do not know how many cells you want to check. So I give you an own
example:
You want to check the cells A1 to H1. Write into cell I1 the formula:
=min(isblank(A1:H1)*column(A:H)*100+not(isblank(A1:H1))*column(A:H))
and enter this formula not with the Enter key but with the combination
of Control + Shift + Enter (Matrix formula).
The result is the Number of the column of the first not empty cell. If
you want the letter of the column then you write:
=
char
(min(isblank(A1:H1)*column(A:H)*100+not(isblank(A1:H1))*column(A:H))+64)
Depending on how many rows you want to check, copy this formula down
as often as necessary
Regards (Schönen Gruß)
Klaus from Canada
On 27-Feb-09, at 3:08 PM, axel.stamm...@student.hu-berlin.de wrote:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)
Comment: Made with pgp4pine 1.76
iEYEARECAAYFAkmoVlAACgkQcK38PJiB3dSRMQCgw7xRvCeVJyp4ggvlb0R3ded+
PuUAoIhY5piXNzae+f6LhSrWG8BehvXu
=aPAE
-----END PGP SIGNATURE-----
_______________________________________________
gnumeric-list mailing list
gnumeric-list@gnome.org
http://mail.gnome.org/mailman/listinfo/gnumeric-list
_______________________________________________
gnumeric-list mailing list
gnumeric-list@gnome.org
http://mail.gnome.org/mailman/listinfo/gnumeric-list
