I5{=INDEX(C:C,SMALL(IF((MMULT(N(SUMIF(C$5:C$15,C$5:C$15,OFFSET(C$5:C$15,,{1,2,3,4}))>0),{1;1;1;1})>={1,2,3,4})*(MATCH(C$5:C$15,C:C,)=ROW($5:$15)),ROW($5:$15),99),ROW(A1)))&""
J5{=IFERROR(INDEX($4:$4,RIGHT(SMALL(IF((C$5:C$15=O5)*(SUMIF(C$5:C$15,C$5:C$15,OFFSET(C$5:C$15,,{1,2,3,4}))>0),ROW(1:11)/1%+COLUMN(D:G)),COUNTIF(O$5:O5,O5)),2)),"")
K5=SUMPRODUCT((C$5:C$15=I5)*(D$4:G$4=J5)*D$5:G$15)
留言
張貼留言