表格中同一个人的多项列备注变成横向行标记

LCWEM123 · 发表于 2024-11-20 13:46

表格中同一个人的多项列备注变成横向行标记，求公式

你是那块小饼干 · 发表于 2024-11-20 13:56

=IF(ISNUMBER(MATCH($J2&$K2&L$1,$B$2:$B$11&$C$2:$C$11&$D$2:$D$11,0)),"√","")

复制代码

又拉下啦

lachenfei · 发表于 2024-11-20 14:05

=IF(XLOOKUP($J7&$L$1:$R$1,$B:$B&$D:$D,$D:$D,"",0)<>"","√","")

复制代码

mykitami · 发表于 2024-11-20 14:32

=LET(s,PIVOTBY(HSTACK(MATCH(B2:B21,B2:B21,),B2:C21),HSTACK(MATCH(D2:D21,D2:D21,),D2:D21),D2:D21,LAMBDA(x,CONCAT(IF(x<>"","√",""))),0,0,,0,,B2:B21<>""),a,DROP(TAKE(s,,3),2,1),b,DROP(s,1,3),HSTACK(VSTACK({"编号","姓名","性别"},HSTACK(SEQUENCE(ROWS(a)),a)),b))

richardzhu15 · 发表于 2024-11-20 15:11

=DROP(PIVOTBY(B2:C11,D2:D11,D2:D11,LAMBDA(x,IF(x>0,"√","")),0,0),,-1)

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

[求助] 表格中同一个人的多项列备注变成横向行标记