Forum Discussion
Alphabetise help
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).
I would start by using a structured Excel table. Then you don't need to worry about the extra rows that may occur. When you add extra rows, the table will automatically expand and the SORTBY formula will pick-up the expanded table.
Riny_van_Eekelen Thank you so much for your response. Great idea. I’ve tried it but I’m just getting #SPILL
Ive linked the table which is called responses but it won’t have it
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).
- Yes! You’ve solved it! Thank you so much! You’re really helping me understand.