D2:D16{=IF(COUNTIF(B$2:B2,B2)=1,MIN(IF(B$2:B$16=B2,C$2:C$16)),"")
F2:G9{=IFERROR(OFFSET($B$1,RIGHT(LARGE(IF($D$2:$D$16<>"",$D$2:$D$16/1%+ROW($1:$15)),ROW(A1)),2),(A$2=$B$2)*2),"")
I2:I9{=IFERROR(INDEX(B:B,RIGHT(LARGE(IF(MATCH(B$2:B$16,B:B,)=ROW($2:$16),RIGHT(SMALL(IF(B$2:B$16=TRANSPOSE(B$2:B$16),TRANSPOSE(C$2:C$16),999)*10^4+ROW($2:$16)*100000001,ROW($1:$15)*15-14),8)*1),ROW(A1)),2)),"")
J2:J9{=IF(I2="","",MIN(IF(B$2:B$16=I2,C$2:C$16)))
留言
張貼留言