自动筛选学生花名册

byzlgzxxx · 发表于 2024-9-5 15:54

求助各位大神:按要求筛选出符合条件的学生填充到单元格中,加上边框.先谢谢啦!

xlllw203 · 发表于 2024-9-5 16:02

=LET(a,FILTER(Sheet1!A2:C11,Sheet1!J2:J11=C12),HSTACK(SEQUENCE(COUNTA(TAKE(a,,1))),a))

复制代码

hugeinfo · 发表于 2024-9-5 16:02

=LET(a,FILTER(CHOOSECOLS(Sheet1!A2:J11,1,2,3),Sheet1!J2:J11=C12),HSTACK(SEQUENCE(ROWS(a)),a))

wgreen · 发表于 2024-9-5 16:03

序号：if(c15<>"",row(a1),"");筛选：=FILTER(Sheet1!A2:C11,Sheet1!J2:J11=Sheet2!C12)

quqiyuan · 发表于 2024-9-5 16:08

=INDEX(Sheet1!A:A,SMALL(IF(Sheet1!$J$2:$J$11=$C$12,ROW($2:$11),4^10),ROW(A1)))&""

byzlgzxxx · 发表于 2024-9-5 16:10

谢谢各位大神!我试试啊,我小白,谢谢大家了!

byzlgzxxx · 发表于 2024-9-5 16:17

quqiyuan 发表于 2024-9-5 16:08
=INDEX(Sheet1!A:A,SMALL(IF(Sheet1!$J$2:$J$11=$C$12,ROW($2:$11),4^10),ROW(A1)))&""

我输入完这样呢?

quqiyuan · 发表于 2024-9-5 16:20

数组3键：Ctrl+shift+enter

byzlgzxxx · 发表于 2024-9-5 16:22

quqiyuan 发表于 2024-9-5 16:20
数组3键：Ctrl+shift+enter

好使啦!谢谢谢谢!!!

		自动登录	找回密码
密码			免费注册

[求助] 自动筛选学生花名册