Find Parent that is not blank or row with no children

Ferdi Retief

How do I find whether a cell is a parent and not blank?

I have tried

=IF(AND(NOT(ISBLANK(Description@row)), COUNT(CHILDREN(Description@row)) > 0), 1, 0)

which gives me the parent and not blank, but it does not give me rows that do not have any children.

I need rows that are parents and not blank + rows that do not have children and are not blank

Appreciate your help

Paul Newcome

How many different hierarchy levels do you have?