英文:
How can I find the largest value in a row and return a certain value based on which cell it is?
问题
我想找到“PAID”列中的最大数，并根据它来确定来自哪个单元格的指示器，以找出谁拥有最多的已付记录。如果存在并列情况，我也希望列出两个指示器。我该如何操作？
英文:
I want to find the largest number in the "PAID" column in a row and return an indicator based on which cell it comes from to find who has the highest number of paid records. I also want it to list both indicators if there is a tie. How could I go about this?
答案1
得分: 1
这是一个你可以根据特定需求进行调整的选项：
在单元格 A9 中的公式：
=LET(y,TAKE(WRAPROWS(A1:T1,4),,1),TEXTAFTER("|"&TEXTBEFORE(BYROW(A2:T6,LAMBDA(r,LET(x,INDEX(WRAPROWS(r,4),0,3),TEXTJOIN("|",FILTER(y,x=MAX(x)))&REPT("|",ROWS(y))))),"|",SEQUENCE(,ROWS(y))),"|",-1))
英文:
Here is one option you could adapt to fit your specific needs:
Formula in A9:
=LET(y,TAKE(WRAPROWS(A1:T1,4),,1),TEXTAFTER("|"&TEXTBEFORE(BYROW(A2:T6,LAMBDA(r,LET(x,INDEX(WRAPROWS(r,4),0,3),TEXTJOIN("|",,FILTER(y,x=MAX(x)))&REPT("|",ROWS(y))))),"|",SEQUENCE(,ROWS(y))),"|",-1))
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论