The Offset equations seem to work as intended with one remark. The "working filter" you have in the same column is going to add an additional cell to the range that you don't intend. Of course, I understand this is only there for illustrative purposes.

Nor do I see how it would mess things up. I moved the "working filter over" and the ranges pointed correctly but the data validation still doesn't work.