How to filter rows that contain all values from a multi-select field (exclusive match, not OR)?

How To
,
1

Hi everyone,

I’m new to Make and need help with filtering data from an Excel sheet based on answers collected through a Tally form.

One of the questions in the form is:
“What hobbies do you have?”
Respondents can select multiple options, for example: “dancing”, “reading”, and “cooking”.

I want to filter my Excel sheet to only include the rows that contain all of the selected hobbies — i.e., the row must contain “dance”, “read”, and “cook”, regardless of the order in the column kind of hobbies.

Here’s what I’ve tried:

  • I used an Iterator to separate the selected values.
  • Then I used a filter with the condition:
    <Contains (case insensitive) What hobby do you have [bundle order position]>
    But this seems to behave like an OR, returning rows that contain any of the hobbies, instead of all of them.

What I need is a way to filter the sheet only if all selected values are found in the row, not just one.

Does anyone know how to build a filter like that in Make?

Thanks in advance!

2

I’ve run into this same issue when trying to match rows that contain all selected values—not just one. The workaround that helped me was using a custom formula with FILTER() and ARRAYJOIN() to compare against the full selected set as a string. Not perfect, but it works until native support improves. Would love to see an official “match all tags” operator.