G2:G12{=IFERROR(RIGHT(SMALL(IF(B$2:B$5-(COLUMN(A:I)-1)*$C$2>0,SUBSTITUTE(TEXT(B$2:B$5-(COLUMN(A:I)-1)*$C$2,"[>"&$C$2&"]"&SUBSTITUTE($C$2,0,"~")&";[>]0;~"),"~",0)+ROW($1:$4)*10^8+COLUMN(A:I)*10^7),ROW(A1)),7)*1,"")
H2:O5=TEXT(MIN($B2-(COLUMN(A1)-1)*$C$2,$C$2),"0;;")
留言
張貼留言