C2{=IFERROR(CHAR(MIN(IFERROR(IF(COUNTIF(C$1:C1,TRIM(MID(SUBSTITUTE(B$2:B$8,"+",REPT(" ",9)),{1,10,19},9)))=0,CODE(TRIM(MID(SUBSTITUTE(B$2:B$8,"+",REPT(" ",9)),{1,10,19},9)))),""))),"")
D2{=IFERROR(CHAR(RIGHT(MIN(IFERROR(IF(COUNTIF(D$1:D1,TRIM(MID(SUBSTITUTE(B$2:B$8,"+",REPT(" ",9)),{1,10,19},9)))=0,ROW(2:8)/1%%+{1,2,3}/1%+CODE(TRIM(MID(SUBSTITUTE(B$2:B$8,"+",REPT(" ",9)),{1,10,19},9)))),"")),2)),"")
留言
張貼留言