如何用filter筛选出4月在职的职工名单

guoliyan1

向大神求助，如题：b列c列为空的对应职工是在职状态

jerrike

1. =TOCOL(FILTER(A:A,(B:B="")+(B:B>4)*ISNUMBER(B:B)),3)

复制代码

guoliyan1

jerrike 发表于 2024-12-11 20:14

a18职工会被筛选进去

zwzc

=FILTER(A2:A27,(IF(B2:B27="",1,B2:B27>4))*(IF(C2:C27="",1,C2:C27<=4)))

quqiyuan

1. =INDEX(A:A,SMALL(IF((IF($C$2:$C$27<>"",$C$2:$C$27<=--LEFTB($D$1,2),1))*(IF($B$2:$B$27<>"",$B$2:$B$27>=--LEFTB($D$1,2),1)),ROW($A$2:$A$27),4^10),ROW(A1)))&""

复制代码

lchengjun

=FILTER(A2:A27,(C2:C27<4)*(C2:C27<>"")*((B2:B27>=4)+(B2:B27="")))

guoliyan1

zwzc 发表于 2024-12-11 20:34
=FILTER(A2:A27,(IF(B2:B27="",1,B2:B27>4))*(IF(C2:C27="",1,C2:C27

谢谢，大神的公式满足了我的目的

祝洪忠-

=FILTER(A2:A27,(C2:C27<4)*((B2:B27="")+(B2:B27>4)))

柚一

大神们牛！

jerrike

guoliyan1 发表于 2024-12-11 20:18
a18职工会被筛选进去

1. =TOCOL(FILTER(A:A,(C:C<5)*((B:B="")+(B:B>4)*ISNUMBER(B:B))),3)

复制代码