彙整 對齊同客戶 (13649)

E3{=IFERROR(INDIRECT(TEXT(MIN(IF((COUNTIF(E$2:E2,A$3:C$11)=0)*({1,2,3}<>2),ROW($3:$11)/1%+{1,2,3})),"!R0C00"),)&"","")

G3:G16=IF(COUNTIF(A:A,$E3),$E3,"")

H3:H3=IF(G3="","",VLOOKUP(G3,A:B,2,))

G3:H16複製到 I3:J16