如何根据时间先后达标统计排名

qsnail

根据时间先后达标的排名.rar (11.5 KB, 下载次数: 25)

2024-10-5 14:45 上传

点击文件名下载附件

如图：请大神指点

pgp5866

=IF(B2>4,MATCH(A2,UNIQUE(FILTER(业务发展!B$2:B$57,COUNTIF(OFFSET(业务发展!B$2,,,ROW($1:$56)),业务发展!B$2:B$57)>4)),),"")

solextrade

=IF(B2>4,COUNT(0/(MIN(IF(COUNTIF(OFFSET(业务发展!B$2,,,ROW($1:$99)),A2)=5,ROW($1:$99)))>=IF(COUNTIF(OFFSET(业务发展!B$2,,,ROW($1:$56)),业务发展!B$2:B$57)=5,ROW($1:$56),99))),"")

mykitami

=COUNTIF(业务发展!B:B,A2)
=LET(a,COUNTIF(TAKE(业务发展!$B$2:$B$57,SEQUENCE(ROWS(业务发展!$B$2:$B$57))),业务发展!$B$2:$B$57),s,UNIQUE(FILTER(业务发展!$B$2:$B$57,a>=5)),IFNA(MATCH(A2,s,),""))

quqiyuan

1. =TEXT(SUM((MIN(IF(COUNTIF(OFFSET(业务发展!$B$2,,,ROW($1:$1000)),A2)=5,ROW($1:$1000)))>=IF(COUNTIF(OFFSET(业务发展!B$2,,,ROW($1:$1000)),业务发展!B$2:B$1001)=5,ROW($1:$1000)))*1),"0;;;")

复制代码

飞天篮球猪

仅供参考...

ww87725244

=IF(B2>4,SUM(N(MAX(IF(业务发展!$B$2:$B$57=统计!A2,ROW($1:$56),""))>=IF(COUNTIF(OFFSET(业务发展!$B$2,,,ROW($1:$56)),业务发展!$B$2:$B$57)=5,ROW($1:$56),99))),"")

leepoison

=LET(a,MAP(A2:A13,LAMBDA(x,IFERROR(TAKE(DROP(FILTER(业务发展!A2:A57,业务发展!B2:B57=x),4),1),9^9))),IF(a=9^9,"",MAP(a,LAMBDA(y,SUM(1*(a<=y))))))

你是那块小饼干

1. =LET(T,SCAN(0,业务发展!$B$2:$B$57,LAMBDA(X,Y,COUNTIF(业务发展!$B$2:Y,Y))),IFNA(MATCH(A2,INDEX(SORT(FILTER(业务发展!$A$2:$B$57,T=5,""),1,1),,2),0),""))

复制代码