D2:D16{=MIN(IF(A$2:A$16=A2,C$2:C$16))
F2:H16{=INDEX(A:A,RIGHT(SMALL($D$2:$D$16/1%%+$C$2:$C$16/1%+ROW($2:$16),ROW(A1)),2))
L2:N16{=INDEX(A:A,RIGHT(SMALL(INDEX($C:$C,N(IF({1},MATCH(0&$A$2:$A$16,COUNTIFS($A:$A,$A$2:$A$16,$C:$C,"<"&$C$2:$C$16)&$A$2:$A$16,)+1)))/1%%+$C$2:$C$16/1%+ROW($2:$16),ROW(A1)),2))
留言
張貼留言