Download Excel File: https://excelisfun.net/files/EMT1679.xlsx
Learn that spilled arrays do not work in Excel Tables, so we revert to using relative and absolute cell references.
Error Message when you try to create a Spilled Array Formula in an Excel Table: “The formula you typed could return multiple items, which is not supported in Excel Tables”.
Topics:
1. (00:00) Introduction.
2. (00:17) Standard Formula.
3. (01:00) Spilled Array Formula.
4. (01:48) Spilled Array in Excel Table.
5. (02:12) Excel Table formula.
6. (02:46) Options to auto fill in Excel Table Column.
7. (03:02) Summary and Video Links.
Error Message when you try to create a Spilled Array Formula in an Excel Table: The formula you typed could return multiple items, which is not supported in Excel Tables.