Hi Everyone!
I have this formula and the problem with it is that since there are so many rows to fill, it takes long to calculate threads and so on, so I wonder if there is a dynamic array alternative for it that does not require so many calculations:
For example, I have this formula
that works perfectly as an array. Thanks
I have this formula and the problem with it is that since there are so many rows to fill, it takes long to calculate threads and so on, so I wonder if there is a dynamic array alternative for it that does not require so many calculations:
Excel Formula:
=IFERROR(TEXTJOIN(", "; TRUE; FILTER(Seasons!$O:$O; Seasons!B:B=Stats!B2));"")
Excel Formula:
=SORT(UNIQUE(FILTER(Seasons!B:B;NOT(ISNUMBER(VALUE(SUBSTITUTE(Seasons!B:B;"-";"")))))))