The attached seems to work , although I think it could be made simpler.

It uses array formulas to be committed with Ctrl+Shift+Enter

Attached Files

Copy of Example.xlsx (16.1 KB, 10 views)

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post