Using two criteria to show records

[iftttnewbie]

Hi all,

I want to create a simple list or query where there is a filter (e.g. UKGermany) and it will only show company records with this criteria selected.

My difficulty is that each company can have more multiple criteria, e.g. UKGermany as well as UKFrance or even GermanyUK (different to UKGermany).

What's the easiest way to create list that will allow me to filter these options?

Many thanks

Andy

 

[C Moore]

The new dynamic arrays FILTER function should work in conjunction with SEARCH and a data validated drop down list. If they are in separate columns you can create a 'text search' column that uses TEXTJOIN to be your search column.