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.
hi quadraple,
could you please let me understand filter part in above formula?
could you please let me understand filter part in above formula?