Forum Discussion
What is excel's oldest version to have spill formulas?
I currently have Office 365 ProPlus Version 2002 build 12527.20278 and it does not support spill formulas. What version do I need to install to have them?
2 Replies
If I'm correct that is called now Microsoft 365 Apps for Enterprise semi-annual channel. If so, dynamic arrays were deployed on it previous summer Archived Release notes for Semi-Annual Channel releases - Office release notes | Microsoft Docs
If that's not 365 ProPlus, when dynamic arrays are not available for such.
- If by Spill formulas you mean the recent UNIQUE and FILTER, the Dynamic Array functions, you need the most recent version. But if you're updating at all, why would you not want to update to the most recent anyway?
