匹配唯一列
Edit
- 如果您更喜欢 1 和 0,请将“是”-es 和“否”-s 替换为它们。
=LET(d,A2:D12,uc,1,y,"Yes",n,"No",
ud,INDEX(d,,uc),u,UNIQUE(ud),um,XMATCH(ud,u),
us,XMATCH(SEQUENCE(ROWS(u)),um),
ui,INDEX(d,us,SEQUENCE(,COLUMNS(d))),
nc,BYROW(u,
LAMBDA(r,ROWS(UNIQUE(FILTER(d,ud=r)))=1)),
HSTACK(ui,IF(nc,y,n)))
=LET(d,A2:D12,uc,1,y,"Yes",n,"No",
ud,INDEX(d,,uc),u,UNIQUE(ud),
nc,BYROW(u,
LAMBDA(r,ROWS(UNIQUE(FILTER(d,ud=r)))=1)),
HSTACK(u,IF(nc,y,n)))
初始帖子
=LET(d,A2:D12,uc,1,
ud,INDEX(d,,uc),u,UNIQUE(ud),um,XMATCH(ud,u),
us,XMATCH(SEQUENCE(ROWS(u)),um),
ui,INDEX(d,us,SEQUENCE(,COLUMNS(d))),
nc,BYROW(DROP(ui,,1),
LAMBDA(r,--(COLUMNS(UNIQUE(r,1))=1))),
HSTACK(ui,nc))