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.
=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.
Hey,
Thank you for your response, could you link me the original file, it doesn't seem to work for me.
It says the first COUNTIFS function has to many arguments ...
Thank you very much,
Best Regards,
Dieter Watelle
Thank you for your response, could you link me the original file, it doesn't seem to work for me.
It says the first COUNTIFS function has to many arguments ...
Thank you very much,
Best Regards,
Dieter Watelle
I can send you the .pdf with the original file however it's in german. I can use formulas such as FILTER, UNIQUE and LET in Excel online but to my knowledge i can't attach these files to my post.
- Hey !
Just noticed, i made a translation error myself "English => Dutch", works perfect now, thank you !