Forum Discussion
LuluLehman
Jun 28, 2023Copper Contributor
Filter with Multiple Criteria
My spreadsheet filters contacts to those meeting 9 criteria. Not all criteria need to be met. My filter includes each criteria (using "*"). However, many cells in the data file are blank, which ar...
Patrick2788
Jun 28, 2023Silver Contributor
Here's an example where there's 3 criteria:
=LET(
k, COLUMNS(crit),
arr, SEQUENCE(k, , 1, 0),
FILTER(data, MMULT((crit = input) * 1, arr) = k)
)