G2{=INDEX(A:A,RIGHT(LARGE(OFFSET(B$2:B$16,,MAX(INT((ROW(A1)-1)/3)))/1%+ROW($2:$16),COUNTIF(F$2:F2,F2)),2))
H2{=VLOOKUP(G2,IF({1,0},A$2:A$16,OFFSET(B$2:B$16,,MAX(INT((ROW(A1)-1)/3)))),2,)
J2:K10{=OFFSET($A$1,RIGHT(LARGE({3,2,1}*10^6+$B$2:$D$16/1%+ROW($1:$15),COUNTIF($F$2:$F2,$F2)+INT((ROW(A1)-1)/3)*15),2),INT(ROW(A3)/3)*(A$1=$B$1))
B2:D16格式化=B2>=LARGE(B$2:B$16,3)
留言
張貼留言