Hi -
I've asked a version of this question previously, but my new example is more complicated and has to account for a scenario where I am filling in hierarchical categories in a column, but different parts of the hierarchy may be missing in some cases.
In the attached sheet, Columns A:C are what I already have, Columns D:F are what I am trying to create. You'll see that there is a basic FUNCTION -> SERIES -> GROUP -> Title hierarchy, but in some cases there is "No Group," and in one case there is also "No Series."
How do I construct a formula that achieves this result. Previously I used a version of this: =IF(A2="**",C2,E1) but I've expanded to a four-level hierarchy and can't figure out how to handle missing steps in the hierarachy, all while creating the asterisks in the D:F columns.
Bookmarks