判斷客户保有情况 (11240)

S2{=TEXT(MAX(IF(OFFSET(A2,,MATCH(TEXT(EOMONTH(U$2,-1),"YYYMM")*1,$1:$1,)-1,,-6),COLUMN(A:F),))-1,"保有;流失;保有 (流失预警)")

另解{=LOOKUP(SUM(N(OFFSET(A2,,MATCH(TEXT(EOMONTH(U$2,-1),"YYYMM")*1,$1:$1,)-1,,-6)>0)*COLUMN(A:F)),{0,1,2},{"流失","保有 (流失预警)","保有"})