G2{=IFERROR("C"&SMALL(IF((IFERROR(LEFT(SUBSTITUTE(TRIM(MID(SUBSTITUTE(SUBSTITUTE(F$2,"C",),",",REPT(" ",99)),ROW($1:$9)*99-98,99)),"-",REPT(" ",9)),9)*1,999)<=COLUMN(A:CU))*(IFERROR(RIGHT(SUBSTITUTE(TRIM(MID(SUBSTITUTE(SUBSTITUTE(F$2,"C",),",",REPT(" ",99)),ROW($1:$9)*99-98,99)),"-",REPT(" ",9)),9)*1,999)>=COLUMN(A:CU)),COLUMN(A:CU)),ROW(A1)),"")
留言
張貼留言