；兩個方法：；一、不用陣列公式，家一個輔助列；H2=G2&COUNTIF(G$2:G2,G2)向下複製；A2=IF(ISERROR(VLOOKUP($G$2&ROW(A1),IF({1,0},Sheet1!$H$2:$H$7,Sheet1!A$2:A$7),2,0)),"",VLOOKUP($G$2&ROW(A1),IF({1,0},Sheet1!$H$2:$H$7,Sheet1!A$2:A$7),2,0))向右向下複製。；二、不加輔助列，用陣列公式；A8=INDEX(Sheet1!A:A,SMALL(IF(Sheet1!$G$2:$G$7=$G$8,ROW(Sheet1!$G$2:$G$7),4^8),ROW(A1)))&""向下複製、向右複製到E列；F8=IF(A8="","",INDEX(Sheet1!F:F,SMALL(IF(Sheet1!$G$2:$G$7=$G$8,ROW(Sheet1!$G$2:$G$7),4^8),ROW(F1))))向下複製；陣列公式，公式輸完後，游標放在公式編輯欄同時按下CTRL+SHIFT+回車鍵，使陣列公式生效；注意F列時間設定為日期格式。