Greetings excel gurus!
I'm having trouble getting Excel to return expected results. I must be using the wrong syntax, and can't figure it out.
Named range 1: Fiscal_Yr; rows A1-A1000 and the values in that range use data validation list ranging from 16 to 40.
Named range 2: In_Plan; rows...