find first data in a row

  • Thread starter Thread starter joris adriaenss
  • Start date Start date
J

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
 
Thanks, Domenic and Alan

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