如何求最大的物品

jisijie630 · 发表于 2022-11-3 20:21

=CHAR(101-MATCH(MAX(MMULT({1,1,1},MOD(LARGE(B2:B39^(A2:A39={"a","b","c","d"})+{1,2,3,4}/1%%,{1,39,77,115}+{0;1;2}),1000))),MMULT({1,1,1},MOD(LARGE(B2:B39^(A2:A39={"a","b","c","d"})+{1,2,3,4}/1%%,{1,39,77,115}+{0;1;2}),1000)),))

jivy1212 · 发表于 2022-11-4 09:28

=LOOKUP(1,0/FREQUENCY(0,9^9-MMULT({1,1,1},MOD(LARGE(IF(A2:A39={"a","b","c","d"},B2:B39+{1,2,3,4}/1%%,{1,2,3,4}/1%%),38*{0,1,2,3}+{1;2;3}),10^4))),{"d";"c";"b";"a"})

复制代码

piny · 发表于 2022-11-4 09:56

本帖最后由 piny 于 2022-11-4 11:09 编辑

dim麻辣君发表于 2022-11-3 18:32
函数的话大概这样子吧

好方法, 中心思路不變, 改寫一個

=CHAR(96+RIGHT(MAX(MMULT(E1:AP1+1,(COUNTIFS(A:A,A2:A39,B:B,">"&B2:B39)<3)*B2:B39*({"a","b","c","d"}=A2:A39))/1%+{1,2,3,4})))

hcm19522 · 发表于 2022-11-4 12:57

本帖最后由 hcm19522 于 2022-11-4 13:02 编辑

C2:C21=IF(COUNTIF(A$2:A2,A2)=1,SUMPRODUCT((COUNTIFS(A:A,A$2:A$21,B:B,">"&B$2:B$21)<3)*(A$2:A$21=A2)*B$2:B$21),)

E2=LOOKUP(1,0/(MAX(C:C)=C2:C21),A2:A21)

F2{=INDEX(A:A,RIGHT(MAX(MMULT(N(A2:A21=TRANSPOSE(A2:A21)),(COUNTIFS(A:A,A2:A21,B:B,">"&B2:B21)<3)*B2:B21)/1%+ROW(2:21)),2))

cinlo · 发表于 2022-11-9 22:21

本帖最后由 cinlo 于 2022-11-9 22:51 编辑

=LOOKUP(1,0/FREQUENCY(0,1/MMULT(MOD(SMALL((A2:A39=TRANSPOSE(A2:A39))*B2:B39+COLUMN(A:AL)*9^9,ROW(1:38)*38-{2,1,0}),9^9),{1;1;1})),A2:A3)

复制代码

=@SORTBY(A2:A39,-MAP(A2:A39,LAMBDA(x,SUM(LARGE((A2:A39=x)*B2:B39,{1,2,3})))))

复制代码

今铭昔 · 发表于 2022-11-9 23:03

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

[已解决] 如何求最大的物品

评分

评分

评分

评分

评分