Can the FILTER formula return more than one columns value?

Copper Contributor

Using FILTER In my table below I want the values of the home and away matches to appear in one drop down search(at the moment i have to do two FILTER dropdowns for home and away). Is there away round this? The HOME (HT) are in "D" and the AWAY ( AT) are in "G" columns.

2021-04-15.png

5 Replies

@16Teams 

If you mean, for your sample, HT=Serbia OR AT=Serbia, when like

=FILTER(A2:G76, (D2:D76=I2)+(G2:G76=I2) )

@16Teams 

You need to introduce an OR condition into the filter.  With arrays, this is achieved with the arithmetic '+' operator.

= FILTER(Fixtures, (Fixtures[HT]=Country)+(Fixtures[AT]=Country))

That did the trick, thanks for your help-Sergei. See you at the next problem!
Got it sorted Peter thanks for your info.

@16Teams 

You are welcome, glad to help