M
mark.wolven
I have an Org Tree type spreadsheet. Looking at it, it is easy to see whichcell contains the information about it's parent. But I would like to be able to extract a set of Parent/Child Pairs. I have an Index/Match that returns the column header, so, I can see the level of each node.
However, a node may be in row 100, at Level 4 (4 levels deep in the hierarchy). It's parent should be the nearest Level 3 node in rows 1-99. And by nearest, I mean the highest row, closest to row 100.
Is there any way to do that within a function?
However, a node may be in row 100, at Level 4 (4 levels deep in the hierarchy). It's parent should be the nearest Level 3 node in rows 1-99. And by nearest, I mean the highest row, closest to row 100.
Is there any way to do that within a function?