Forum Discussion
Solved
Filter Items based on condition per other condition...?
Hello,
I have searched for quite some time now this Forum and I am not sure if the naswer is already here - if it is, sorry...
I think the first problem is me explaining the issue.... But I will try!
I have a table with a few columns - the ones that matter are 3 columns. Example:
| Column1 | Column2 | Column3 |
| AAA | YES | red |
| AAA | NO | red |
| AAA | NO | red |
| BBB | YES | blue |
| CCC | YES | green |
| CCC | NO | purple |
| CCC | YES | red |
| BBB | NO | green |
Basically what I want is to find a way to only show the entries from Column1 that ONLY and ONLY have a YES in Column2 per color of Column3 - not sure it is clear...
In this scenario, only BBB would appear since the other entries have both YES and NO in Column2 per color in Column3.
Let me know if you can help me . if it is not clear, I can provide an excel file with this to try and help as much as I can for you to help me 🙂
Thanks;
Ricardo
pls try this
