Forum Discussion
Graeme_Clark2295
May 05, 2024Copper Contributor
Alphabetise help
Everyone has been so helpful on this forum; there are really some true experts. I’m making tracks with Excel but have really hit a stumbling block which seems like it should be an easy fix but I just...
- May 05, 2024
The SPILL error occurs because you use the formula inside a structured table, and that won't work. Such tables can't have dynamic array functions (i.e. ones that are spilling their results into multiple cells at once).
Riny_van_Eekelen
Platinum Contributor
The SPILL error occurs because you use the formula inside a structured table, and that won't work. Such tables can't have dynamic array functions (i.e. ones that are spilling their results into multiple cells at once).
Graeme_Clark2295
May 06, 2024Copper Contributor
Yes! You’ve solved it! Thank you so much! You’re really helping me understand.