取Data 1數據 D3:D5{=INDEX(A:A,SMALL(IF(A$2:A$9>0,ROW($2:$9),99),ROW(A1)))&""
取Data 2不重複 E2:I2{=INDEX($B:$B,MIN(IF(COUNTIF($D2:D2,$B2:$B9)=0,ROW(2:9),99)))&""
E3:I5=IF($D3="","",SUMPRODUCT((LOOKUP(ROW(2:9),ROW(2:9)/($A$2:$A$9>0),$A$2:$A$9)-$D3=0)*($B$2:$B$9=E$2)))
留言
張貼留言