C3{=IFERROR(INDEX(TRIM(MID(SUBSTITUTE(SUBSTITUTE(A$3:A$6,"-",","),",",REPT(" ",99)),{1,2,3}*198-197,99)),LEFT(SMALL(IF(COUNTIF(C$2:C2,TRIM(MID(SUBSTITUTE(SUBSTITUTE(A$3:A$6,"-",","),",",REPT(" ",99)),{1,2,3}*198-197,99)))=0,{1;2;3;4}/1%+{1,2,3}),1)),RIGHT(SMALL(IF(COUNTIF(C$2:C2,TRIM(MID(SUBSTITUTE(SUBSTITUTE(A$3:A$6,"-",","),",",REPT(" ",99)),{1,2,3}*198-197,99)))=0,{1;2;3;4}/1%+{1,2,3}),1))),"")
D3{=IF(C3="","",SUM(IFERROR(SUBSTITUTE(MID(SUBSTITUTE(A$3:A$6,",",REPT(" ",99)),{1,2,3}*99-98,99),C3&"-",)*1,)))
留言
張貼留言