这里有两个建议可供测试:
Case 1:
=LET(qtlist,BYROW(E3:G,LAMBDA(each,MAX(FILTER({3,2,1},each)))),MAP(B3:B,D3:D,qtlist,LAMBDA(title,year,qt,IF(title="","",IF(MAX(FILTER(qtlist,B3:B=title,D3:D=year))>qt,"Yes","No")))))
Case 2:
=LET(qtlist,BYROW(E3:G,LAMBDA(each,MAX(FILTER({3,2,1},each)))),MAP(B3:B,D3:D,qtlist,LAMBDA(title,year,qt,IF(title="","",IF(COUNTA(FILTER(qtlist,qtlist=qt,B3:B=title,D3:D=year))>1,"Yes","No")))))
基本上,他们的工作原理是创建质量排名,并按这些列中的数字进行过滤。在情况 1 中,它与最大值进行比较,在这种情况下,如果存在更大的值,则为 true;在情况 2 中,它会查找是否有多个相等的