Forum Discussion
Solved
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...
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).
Firstly, I agree with Riny_van_Eekelen that it is better to have all input data prepared using Excel Tables, preferably without blank rows. The following formula both sorts and filters:
= SORT(FILTER(Table1, ISTEXT(Table1[Column1])))