79399318
Date: 2025-01-30 09:14:48
Score: 1
Natty:
I'm not sure if this is overkill, but here's my attempt:
=LET(_Data,A2:C6,
_Col1, CHOOSECOLS(_Data,1),
_Col2, CHOOSECOLS(_Data,2),
_Col3, CHOOSECOLS(_Data,3),
_Uni,UNIQUE(_Col1),
_Select,BYROW(_Uni,LAMBDA(a,IF(SUM((_Col1=a)*((_Col2="yes")+(_Col3="yes")))=2,a,""))),
_Drop,FILTER(_Select,_Select<>"","EMPTY"),
_Filter,FILTER(_Data,_Col1=_Drop),
_Filter)
Reasons:
Posted by: Excellor - Probably link only (1):
- Has code block (-0.5):
- Low reputation (0.5):