H2:H7(日期不重複){=IFERROR(INDEX(A:A,SMALL(IF(COUNTIF(H$1:H1,A$2:A$13)=0,ROW($2:$13)),1)),"")
I2:N7{=IFERROR(OFFSET($A$1,SMALL(IF(($A$2:$A$13=$H2)*(MATCH($A$2:$A$13&$B$2:$B$13,$A$2:$A$13&$B$2:$B$13,)=ROW($1:$12)),ROW($1:$12)),INT((COLUMN(A1)-1)/3)+1),MOD(COLUMN(A1)-1,3)+1),"")
留言
張貼留言