Filter and sort

It might be easier (if I've understood) to concatenate all the ingredients in each row into a single delimited string in a fixed (additional) column
With these concatenated strings in place we can then use Text based Filters on the concatenation column to search for rows which include a given ingredient.

Simplified example, B:E contain various fruits (or blank)
We want to return rows that include "apple" but "apple" can reside anywhere in B:E on any given row (or not at all)

Please Login or Register  to view this content.

we can now filter A:F by filtering F for Text Contains: @apple@