单科第一名

欢乐马20221029

筛选出单科第一名

jivy1212

1. =LOOKUP(,0/FREQUENCY(0,9^9-OFFSET($B$2:$B$8,,MATCH(L1,$C$1:$I$1,))),$A$2:$A$8&$B$2:$B$8)

复制代码

右拉

mykitami

=LET(_a,OFFSET($B$2:$B$8,,MATCH(L$1,$C$1:$I$1,)),TEXTJOIN(",",,FILTER($A$2:$A$8&$B$2:$B$8,_a=MAX(_a))))

苏小亓

1. =TEXTJOIN(",",,IF(MAX(C2:C8)=C2:C8,$A$2:$A$8&$B$2:$B$8,""))

复制代码

袁勇

考虑没有同分的情况：

1. =LOOKUP(1,0/(COUNTIF(C:C,">"&C2:C8)=0),$A$2:$A$8&$B$2:$B$8)

复制代码

hugeinfo

=MAP(C1:I1,LAMBDA(a,CONCAT(TAKE(SORT(HSTACK(A2:B8,OFFSET(a,1,,7)),3,-1),1,2))))

欢乐马20221029

苏小亓 发表于 2024-11-25 16:30

并列的往下排，每个单元格只填一个名

苏小亓

欢乐马20221029 发表于 2024-11-25 16:39
并列的往下排，每个单元格只填一个名

1. =FILTER($A$2:$A$8&$B$2:$B$8,MAX(C2:C8)=C2:C8)

复制代码

祝洪忠-

=FILTER($A2:$A8&$B2:$B8,C2:C8=MAX(C2:C8))

小凡、、、