I am trying to filter the below table using the filter formula =FILTER(K2:M20,(K2:K20<>"")(L2:L20<>"")(M2:M20<>""),"No results"):Test Table but my table has few 0 or blank value.
Can we include the filter result to have the value if one of the columns is zero and the other column shows a number? The idea is the filter should only remove the data if both columns are blank. Is this possible? Thank you for the help in advance.