Forum Discussion
Solved
Filter certain project for which everything is finished
Hello everyone, I am searching for a way to do the following: I have a table which looks like this: project part check 1 check 2 Project A 1 OK NOK Project A 2 OK OK Pro...
=LET(e,UNIQUE(A2:A6),ok,COUNTIFS($A$2:$A$6,e,$C$2:$C$6,"OK",$D$2:$D$6,"OK"),project,COUNTIF($A$2:$A$6,e),result,FILTER(e,ok=project),result)Maybe with this formula which seems to work in my sheet.
Please try the formula below.
=IFNA(UNIQUE(FILTER(A2:A6,A2:A6<>FILTER(A2:A6,(C2:C6="nok")+(D2:D6="nok"),""))),"")
=IFNA(UNIQUE(FILTER(A2:A6,A2:A6<>FILTER(A2:A6,(C2:C6="nok")+(D2:D6="nok"),""))),"")