客戶購買金額 大於100 最近二次日期差 (15252)

F2{=INDEX(B:B,MIN(IF(COUNTIF(F$1:F1,B$2:B$99)=0,ROW($2:$99))))&""

G2{=IF(F2="","",SUM(LARGE(IF((B$2:B$99=F2)*(D$2:D$99>99),$C$2:$C$99),{1,2})*{1,-1}))