各區有無日期的姓名 分別聚集單格 (13174)

D2:D17=IFERROR(LOOKUP(1,0/(A$1:A1=A2)/(SIGN(N(+C$1:C1))=SIGN(C2)),D$1:D1)&","&B2,B2)

G2:H5=IFERROR(LOOKUP(1,0/($A$2:$A$17=$F2)/(SIGN($C$2:$C$17)-(A$1=$B$1)),$D$2:$D$17),"")