客戶購買產品最近日期 彙整 (12560)

B2:D16格式化=COUNTIFS($B$2:$B$16,$B2,$C$2:$C$16,$C2,$D$2:$D$16,">"&$D2)

F2:H2 下拉{=INDEX(B:B,SMALL(IF(COUNTIFS($B:$B,$B$2:$B$16,$C:$C,$C$2:$C$16,$D:$D,">"&$D$2:$D$16)=0,ROW($2:$16),4^8),ROW(A1)))&""