G2:H6{=LOOKUP(1,0/(LEN(OFFSET($A$1:$D$1,MAX(($A$1:$D$5=$F2)*ROW($1:$5))-1,))=10^($F$1=F$1)),OFFSET($A$1:$D$1,MAX(($A$1:$D$5=$F2)*ROW($1:$5))-1,))
I2:I6{=LOOKUP(1,0/(COUNTIF(F2:H2,OFFSET(A$1,MAX((MMULT(COUNTIF(F2:H2,A$1:D$5),{1;1;1;1})=3)*ROW($1:$5))-1,,,4))=0),OFFSET(A$1,MAX((MMULT(COUNTIF(F2:H2,A$1:D$5),{1;1;1;1})=3)*ROW($1:$5))-1,,,4))
留言
張貼留言