Re: How can I count (from the left) the number of blank cells before the first non-blank cell?

[Rita & Klaus Kuhnlein <rikla wynndel ca>]

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 stammler 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