How to solve #SPILL error using FILTER() fct

[pom_pom]

Hi,

I am trying to figure out which environements are link to each plant species, as there are for some plant species many different envir., it returns me several results.
Excel gives me then an #SPILL error, how could I fix that ?

Thanks in advance for the help !)

 

[Georgiboy]

You could try to place your formula where is states 'Your Formula' in the below and then set the cells in that column to WrapText:

=TEXTJOIN(CHAR(10),,Your Formula)

Try using the XL2BB addin to paste data here, it is easier for the helpers and you will be more likely to get help.
XL2BB - Excel Range to BBCode