F2{=INDEX(B:B,SMALL(IF(IFERROR(MATCH(B$2:B$16&"Y",B$2:B$16&D$2:D$16,),)=ROW($1:$15),ROW($2:$16),99),ROW(A1)))&""
另解=INDEX(B:B,SMALL(IF((MATCH(B$2:B$16&D$2:D$16,B$2:B$16&D$2:D$16,)=ROW($1:$15))*(D$2:D$16="Y"),ROW($2:$16),99),ROW(A1)))&""
G2=IF(F2="","",COUNTIFS(B:B,F2,D:D,"Y"))
留言
張貼留言