符合姓名 取出 聚單元格 (12865)

D1=MID(IF((A1=G$1)*(C1="休假"),TEXT(B1,"\;m/d")&SUBSTITUTE(D2,TEXT(B1,"\;m/"),"."),D2),1+(ROW()=1),999)

單一符號區隔 D1=MID(IF((A1=G$1)*(C1="休假"),TEXT(B1,"、m/d")&D2,D2),1+(ROW()=1),999)