As part of a large VBA application I have a list arranged in a parents-child fashion
Does anyone have an algorithm that 'walks' the list to identify children who are their own great-great-great-grandparent?
In the screen shot, the parent-child relationships in rows 2 - 17 are non-circular, since no one is their own grandfather
Adding row 18 data, makes the list circular since
DDD is the parent of KKK
KKK is the parent of NNN
NNN is the parent of DDD
The actual application could be 20 or 30 'generations' deep.
Appreciate any thoughts
Paul