When I finally came up with something "workable", I had my doubts about it, though I wasn't sure exactly why. It did work on my test data, both as posted, and as used, though for reasons that must surely be "dumb luck".

Following the chain is exactly what I was missing out on. Thanks for pointing that out.