Forum Discussion
Solved
Year Function returning #REF!; not sure why
I am actually a bit embarrassed for asking this, but I've been trying for 2 days now and cannot figure out why this is happening. I'm using the dynamic tables (but this problem happens in or ou...
- Maybe a named range called "year"?
You have a name conflict - there's named range on DD!A2:A13 that is called "Year". You should avoid using names that conflict with excel's function names.
- Thank you. I will definitely keep that in mind.
