Apr 15 2021 04:47 AM
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.
Apr 15 2021 06:06 AM
If you mean, for your sample, HT=Serbia OR AT=Serbia, when like
=FILTER(A2:G76, (D2:D76=I2)+(G2:G76=I2) )
Apr 15 2021 06:15 AM
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))
Apr 15 2021 10:37 AM
Apr 15 2021 10:38 AM
Apr 15 2021 12:36 PM
You are welcome, glad to help