In my previous posting, at end of it I explained, how to use dynamic Named Ranges to do what you want!
In attachment I redesigned your named ranges, and your formulas started work in way you did want. Additionally I added another range which includes data from both columns, and a couple of columns using this range as example.
|