This allows the validation to move dynamically across the various columns. However, I need the Reference Height to be dynamic. I seem to not be able to figure out a good formula for referencing the very bottom of the entire list reference I am looking into where I have calculated the height using a simple "CountA" statement.
I believe I can construct the formula for you if you attach your sample file with given data and expected results. Certainly, I won’t be using OFFSET for being volatile. I will be using INDEX, the most versatile function from my viewpoint.