客戶第幾次消費資料 找出 (14357)

H2下拉 客戶不重複 提取{=IFERROR(OFFSET(B$1,MATCH(,COUNTIF(H$1:H1,B$2:B$299),),)&"","")

I2:J2 下拉{=IF($H2="","",OFFSET($A$1,RIGHT(SMALL(IF($B$2:$B$299=$H2,$A$2:$A$299/1%%+ROW($1:$298)),$E$2),4),(I$1=$J$1)*2))

D2=IF(A2="","",COUNTIFS(B$2:B22,B2,A$2:A22,"<"&A2)+1)