Forum Discussion
Advanced Filter
Hello. I created a filter that has 2 conditions. 1. If the Ref Cert or the SK Cert is YES, bit should appear. The problem is that if the columns with Ref Exp or SK Exp is blank, then it gives me ...
the result of your IF statement is acting on only I3 and concatenated (&) to the output forcing all the output to be text.. maybe try this:
=LET(out, FILTER(C3:N500,((H3:H500)="YES")+((J3:J500)="YES")), IF(out=0,"",out))