Forum Discussion
Can the FILTER formula return more than one columns value?
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...
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))
Got it sorted Peter thanks for your info.