G2:G6{=IFERROR(INDEX(LEFT(B$2:B$16,FIND("-",B$2:B$16,FIND("-",B$2:B$16)+1)-1),MIN(IF(COUNTIF(G$1:G1,LEFT(B$2:B$16,FIND("-",B$2:B$16,FIND("-",B$2:B$16)+1)-1))=0,ROW($1:$15),99))),"")
H2:J6{=IF($G2="","",INDEX(C:C,RIGHT(MAX(IF(1-ISERR(FIND($G2,$B$2:$B$16)),MID($B$2:$B$16,FIND("-",$B$2:$B$16,FIND("-",$B$2:$B$16)+1)+1,9)/1%+ROW($2:$16))),2)))
留言
張貼留言