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).
ms query:
select * from [Remove 0s$a2:o] order by `first name`
select * from [Remove 0s$a2:o] order by `first name`