C2:H5{=IFERROR(INDEX(IFERROR(ROW(INDIRECT(TRIM(MID(SUBSTITUTE(SUBSTITUTE($B$2,"~",":"),",",REPT(" ",19)),ROW(A1)*19-18,19)))),TRIM(MID(SUBSTITUTE(SUBSTITUTE($B$2,"~",":"),",",REPT(" ",19)),ROW(A1)*19-18,19))),COLUMN(A1)),"")
J2{=IFERROR(SMALL(IF(C$2:H$5<>"",C$2:H$5*1),ROW(A1)),"")
留言
張貼留言