Thank you for the reply’s and sorry for my explaining
Col 1 contains list of Alphanumeric codes. Col 2 is the next code in the hierarchy. (I only have 2 columns and I want to add a third which I can then use auto filter on to select a subset of the lines)
The data is kind of like an org chart. At the top level there are a couple of hundred ‘master’ codes (there are a few thousand rows).
I want to pick a master code and see all the lines which report directly AND indirectly to it. e.g. they report to a code which reports to the the master code.
I don’t know how many layers the structure/hierarchy has.
Logic tells me I first need to identify the lines which report to the master code. e.g. 10 lines.
I then need to identify the lines which report to any one of the 10 lines in step 1. e.g. 900
then continue until I reach the bottom of the hierarchy
Does this help at all?
Every formula I try seems to result in some kind of circular ref.
Laptop will be going out the window soon 🙁
thank you