Or this!
To add reference levels, you have to add names strng#, text# and txtl# with according level number, and add according components to concantenate in name strng.
With this approach, there will be no need for helper columns, but you have to check it out yourself with large number of levels and source rows.
Btw, I checked it out with formula "=IF(1=1,"","") in column A of Sheet1 - the name strng returns empty string when formula in source cell returns empty string.
Update! When adding/editing dynamic names strng#, text# and txtl#, you MUST have some cell (on any sheet) - with same row number as the one you put into name formula - to be active! Otherwise references will be wrong (to wrong row)!
|