how to identify a child cell in an array?

In the following array of 24 rows, there are 7 children (terminal nodes) - shaded yellow for clarity. IN other words, every entry has a child except for the terminal nodes

How to write an excel function or macro that identifies these terminal nodes?