How can I find the largest value in a row and return a certain value based on which cell it is?

Question

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?

Use `MAXIFS()` function. What would be your desired output from given dataset? — Harun24hr, Jun 12 '23 at 02:10
@Harun24hr It would be based on the letter in the header at the start of each color. i.e., SB, N, T, D, or R — cheese10234, Jun 12 '23 at 02:13

score 1 · Accepted Answer · answered Jun 12 '23 at 06:50

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))

answered Jun 12 '23 at 06:50

JvdV

70,606
8
39
70

@ jvdV after this, i simply concatenated the cells into one so i could have it all in one cell. thank you kindly. one more question! is there any way to have something come up if they are all 0's across the row? so it isnt just putting the leftmost column? – cheese10234 Jun 14 '23 at 02:32

How can I find the largest value in a row and return a certain value based on which cell it is?

1 Answers1

Linked