Forum Discussion

Graeme_Clark2295's avatar
Graeme_Clark2295
Copper Contributor
May 05, 2024

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...
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    May 05, 2024

    Graeme_Clark2295 

    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).

Resources