G2:G5{=SUM(N(MMULT((ROW(INDIRECT(MIN(IF(A$2:A$20=E2,B$2:C$20))&":"&MAX(IF(A$2:A$20=E2,B$2:C$20))))>=TRANSPOSE((A$2:A$20=E2)*B$2:B$20))*(ROW(INDIRECT(MIN(IF(A$2:A$20=E2,B$2:C$20))&":"&MAX(IF(A$2:A$20=E2,B$2:C$20))))<=TRANSPOSE((A$2:A$20=E2)*C$2:C$20)),ROW(1:19)^0)=0))
留言
張貼留言