find first data in a row

[joris adriaenss]

Hi,

I have a spreadsheet which contains a tree-structure (contents of
directory)

cel B1 : dir 1
cel C2 : subdir 2a
cel D3 : filename 3a
cel D4 : filename 3b
cel C5 : subdir 2b

Which formula should I use, in unused column A, to decide the "level
of the row.

I used the following formula

=MATCH(CONCATENATE(B1;C1;D1;E1;F1;G1;H1;I1;
J1;K1;L1;M1;N1;O1;P1;Q1;
R1;S1;T1;U1;V1;W1;X1;Y1;Z1)

B1:IV1; 0)

in cel A1 and copied down.
Is there a better one. (The level of nesting directories is now to
limited, concatenation takes only 30 arguments, if I want to make th
maximum level higher, I have to nest concatenation-formulas into on
big concatenation.)

Thanks in advanc

 

[Domenic]

Hi,

try,

=MATCH(TRUE,B1:IV1<>"",0)

entered using CTRL+SHIFT+ENTER.

Hope this helps!

 

[Alan Beban]

=MATCH("*",B1:IV1,0) in Cell A1 copied down.

Alan Beban

 

[joris adriaenss]

Thanks, Domenic and Alan

It worked.
Difficult to find it for me, easy when I saw the solution