COUNTIF DESCENDANTS of the highest ancestor of the row being queried
Data sits at the third structural level of a data table.
I want a column with a value on each row to tell me how many descendants there are from the highest ancestor of that row (i.e. within that structure)
Basically, the current row is 1 of how many descendants?
So all third-level rows will show the same count value within the same structure
As an example, the value is returning correctly for each row when there's an absolute reference for the highest ancestor cell in that particular structure (Role$1348):
But I need each structure to know its own highest ancestor cell for the Role column - I don't want to be creating absolute refs for each structure.
Help Article Resources
Check out the Formula Handbook template!