Hi, not sure if I fully understand but it seems your precedence logic is relatively convoluted.
If you can add a key, of sorts, it will help - I think...
Using your sample file:
the results can then leverage the above, e.g.
if the above isn't what you meant, or you cannot use a key (as outlined) post back ... but... if the logic is as complex as your desired results imply then this may get a bit convoluted.
edit: added attachment to illustrate above -- my results in M (i.e. adjacent to your expected results)... if you add to array 2 the results stay in sync, so I think it apes your logic (just not sure how useful)
Bookmarks