签到表汇总

ufolzq · 发表于 2025-12-8 16:51

如何根据出勤表出勤情况，分别在对应的天数里面批量列出出勤人员名单，例如2025-12-1

出勤表.rar (28.2 KB, 下载次数: 34)

人有言兮是然 · 发表于 2025-12-8 17:08

B4单元格公式：

=FILTER(出勤表!B3:.B999,CHOOSECOLS(出勤表!A3:.AG999,MATCH(--REGEXP(CELL("filename",A1),"(?<=]).+"),出勤表!2:2,0))="出勤")

复制代码

秃头发师 · 发表于 2025-12-8 17:11

=IF(VLOOKUP($B3,INDIRECT(TEXT(C$2,"'YYYY - MM - DD'")&"!B:C"),2,0)=0,"未出勤","出勤")

袁勇 · 发表于 2025-12-8 17:25

=IF(COUNTIF(INDIRECT(TEXT(C$2,"'YYYY - MM - DD'")&"!B:C"),$B3),"出勤","未出勤")

fgq5910 · 发表于 2025-12-8 17:35

只要出勤名单

fgq5910 · 发表于 2025-12-8 17:45

=IFERROR(INDEX(出勤表!$B$2:$B$19, SMALL(IF(出勤表!$C$2:$C$19="出勤", ROW(出勤表!$B$2:$B$19)-ROW(出勤表!$B$2)+1), ROW(A1))), "")

沧海一栗666 · 发表于 2025-12-8 18:36

=FILTER(出勤表!$B$3:$B$20,CHOOSECOLS(出勤表!$C$3:$AG$20,MATCH(RIGHT(CELL("filename",A1),2),RIGHT(TEXT(出勤表!$C$2:$AG$2,"YYYY-MM-DD"),2),0))="出勤")

复制代码

日期格式不规范就是多出工

快乐王子238 · 发表于 2025-12-8 19:27

shift所有表，在单元格里粘贴=LET(arr,1*RIGHT(A1,14),data,出勤表!B3:AG20,brr,HSTACK(TAKE(data,,1),CHOOSECOLS(DROP(data,,1),MATCH(arr,出勤表!C2:AG2,0))),FILTER(INDEX(brr,,1),INDEX(brr,,2)="出勤"))

fgq5910 · 发表于 2025-12-8 22:29

批量列出出勤人员名单

alanyao168 · 发表于 2025-12-9 08:29

=DROP(
REDUCE("",TEXT(C2:AG2,"'YYYY - MM - DD'"),
LAMBDA(x,y,LET(z,INDIRECT(y&"!B3:B999"),HSTACK(x,IF(ISNUMBER(XMATCH(B3:B20,z)),"出勤","未出勤"))))),
,1)

复制代码

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

[求助] 签到表汇总

评分