G2:G12{=INDEX(A:A,SMALL(IF(MMULT(N(COUNTIF(OFFSET(B$1,{1;2;3;4},,,{1,2,3,4}),B$2:E$5)=1),{1;1;1;1})>={1,2,3,4},ROW($2:$5),9),ROW(A1)))&""
J2:K12{=IF(G2="","",INDEX(VLOOKUP(G2*1,A:E,{2,3,4,5},),MIN(IF(COUNTIFS(G$1:G1,G2,H$1:H1,VLOOKUP(G2*1,A:E,{2,3,4,5},))=0,{1,2,3,4}))))
一公式M2:N12{=IFERROR(INDIRECT(TEXT(SMALL(IF(COUNTIF(OFFSET($B$1,{1;2;3;4},,,{1,2,3,4}),$B$2:$E$5)=1,{2;3;4;5}/1%+{2,3,4,5}^(A$1=$B$1)),ROW(A1)),"!R0C00"),),"")
留言
張貼留言