Filter duplicated result

How about:

ISNOTBLANK(
  FILTER(
    "Search",
    AND(
      OR(
        ISBLANK([School]),
        ([School] = [_THISROW].[School])
      ),
      OR(
        ISBLANK([Allergy List]),
        ISNOTBLANK(
          INTERSECT(
            [Allergy List],
            [_THISROW].[Allergy List]
          )
        )
      )
    )
  )
)
1 Like

This looks tight Steve, trying that next (later today) :slight_smile:

2 Likes

Your version (without the extra fields) and my version (with a field for each allergy) have slightly different results, @Steve . I have to study it a little more… not sure why. Thanks for the cleaner AND() syntax replacing the IF statements! :slight_smile:

3 Likes