合并单元格求最大值

dongfangxielong · 发表于 2024-5-21 13:49

miaojohn45 · 发表于 2024-5-21 13:53

本帖最后由 miaojohn45 于 2024-5-21 13:57 编辑

=TOCOL(A2:A16,1)

复制代码

=MAX((INDEX(A:A,LOOKUP(ROW($2:$16),ROW($2:$16)/(A$2:A$16<>"")))=I2)*C$2:C$16)

复制代码

无关岁月 · 发表于 2024-5-21 13:53

=GROUPBY(SCAN("",A1:A16,LAMBDA(_a,_b,IF(_b="",_a,_b))),C1:C16,MAX,3,0)

复制代码

wengjh8848 · 发表于 2024-5-21 13:56

=UNIQUE(A2:A16,,TRUE)

=GROUPBY(SCAN(,A2:A16,LAMBDA(x,y,IF(y="",x,y))),C2:C16,MAX,,0)

hugeinfo · 发表于 2024-5-21 14:04

=REDUCE({"部门","年终奖"},TOCOL(A2:A16,3),LAMBDA(x,y,VSTACK(x,HSTACK(y,MAX(FILTER(C2:C16,LOOKUP(ROW($A$2:$A$16),ROW($A$2:$A$16)/($A$2:$A$16<>""),$A$2:$A$16)=y))))))

edwin11891 · 发表于 2024-5-21 14:32

=LET(sDep,UNIQUE(A2:A16,,TRUE),sFull,SCAN(,A2:A16,LAMBDA(x,y,IF(y="",x,y))),n,MAP(sDep,LAMBDA(x,MAX(FILTER(C2:C16,sFull=x)))),HSTACK(sDep,n))

复制代码

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

[已解决] 合并单元格求最大值