銷售單彙整 依銷售單 (13423)

G3:G9{=INDEX(B:B,SMALL(IF(MMULT(N(T(OFFSET(A$4,ROW($1:$99)*7-7+{0,1},))<>""),{1;1})>={1,2,3},ROW($1:$99)*7-5+{0,0},99),ROW(A1)))&""

H3:H9=IF(G3="","",VLOOKUP(G3,B:E,4,))

I3:L9{=INDEX(A:A,SMALL(IF(MMULT(N(T(OFFSET($A$4,ROW($1:$99)*7-7+{0,1},))<>""),{1;1})>={1,2,3},ROW($1:$99)*7-3+{0,1},99),ROW(A1)))&"")