As far as I know, in Google Sheets filter function cannot be used within arrayformula.
I have a series of cells within the row 5 that would contain formulas with filter.
The first formula would go as follows:=IFERROR(FILTER(Full!AA:AA,Full!AB:AB=A1),).
The second formula would go as follows:=IFERROR(FILTER(Full!AA:AA,Full!AB:AB=A2),) and so on…
The original idea was to use ARRAYFORMULA(IFERROR(FILTER(Full!AA:AA,Full!AB:AB=A:A),) but it’s not allowed.
Do you know of any workaround to enable filtering in several cells managing it all with one single formula?
Thanks.
>Solution :
You can use MAP or BYROW.
=MAP(A1:A,LAMBDA(a,IFERROR(FILTER(Full!AA:AA,Full!AB:AB=a))))