[开_46] 连续项目的筛选问题 ★★★★

jsxjd

kk=IF(Sheet1!$B$4:$B$27<>Sheet1!$B$5:$B$28,ROW(Sheet1!$B$4:$B$27)-3)
kk1=IF(FREQUENCY(ROW(Sheet1!$B$5:$B$28)-3,SMALL(kk,ROW(INDIRECT("1:"&COUNT(kk)-1))+1))>=3,SMALL(kk,ROW(INDIRECT("1:"&COUNT(kk)))))
=T(OFFSET($B$4,SMALL(kk1,ROW(INDIRECT("1:"&COUNT(kk1)))),))

delete_007

D15公式：

1. =INDEX(B:B,SMALL(IF(FREQUENCY(ROW($5:$29),IF(B$4:B$28<>B$5:B$29,ROW($5:$29),))>=3,ROW($4:$29),4^8),ROW(A1)))&""

复制代码

E15公式：

1. =INDEX(B:B,MIN(IF((FREQUENCY(ROW($6:$29),IF(B$5:B$28<>B$6:B$29,ROW($6:$29),))>=3)*(COUNTIF(E$14:E14,B$5:B$29)=0),ROW($5:$29),4^8)))&""

复制代码

F15公式：

1. =INDEX(B:B,RIGHT(MIN(IF((FREQUENCY(ROW($6:$29),IF(B$5:B$28<>B$6:B$29,ROW($6:$29),))>=3)*(COUNTIF(F$14:F14,B$5:B$29)=0),COUNTIF(B$5:B$28,"<"&B$5:B$29)/1%+ROW($5:$29),9^9)),2))&""

复制代码