L2=MID(SUMPRODUCT(RIGHT(SMALL((ROW($1:$9)=COLUMN(A:I))*A$2:I$10+ROW($1:$9)/1%,ROW($1:$9)*9))*10^-ROW($1:$9)),3,K2)
M2=MID(SUMPRODUCT(RIGHT(SMALL((ROW($1:$9)+COLUMN(A:I)=10)*A$2:I$10+ROW($1:$9)/1%,ROW($1:$9)*9))*10^-ROW($1:$9))&REPT(0,9),3,K2)
N2=MID(SUMPRODUCT(RIGHT(SMALL((ROW($1:$9)+COLUMN(A:I)=K2+1)*A$2:I$10+ROW($1:$9)/1%,ROW($1:$9)*9))*10^-ROW($1:$9))&REPT(0,9),3,K2)
留言
張貼留言