How can cells I2:I4 contain the names of the owners of the values in cells H2:H4?
From the Q1 to Q4 value data above, I want to take the 3 highest values (in column “H” I use the LARGE formula). Then in the next column (column “I”) the name of the person who got each value is listed.
Expected results:
I2 = Austin
I3 = Charles
I4 = Austin
May be
{=TEXTJOIN(";";1;IF($B$2:$E$6=LARGE($B$2:$E$6;1);$A$2:$A$6;""))} ?
Or if column H contain value
{=TEXTJOIN(";";1;IF($B$2:$E$6=$H2;$A$2:$A$6;""))}
Hello, thank you for giving the answer. Your answer produced the results I expected. At first I thought it would use a formula like VLOOKUP or QUERY or something like that. But apparently now it is solved with ARRAYFORMULA + TEXTJOIN + IF. Regards
Hallo
Formula in F2:
=MAX(B2:E2)
pull down to F6
Formula in H2;H3;H4:
=LARGE($F$2:$F$6;1)
=LARGE($F$2:$F$6;2)
=LARGE($F$2:$F$6;3)```
Formula in I2:
=INDEX($A$2:$A$6;MATCH(H2;$F$2:$F$6;0))
pull down to I4
Hello, thank you for answering. But that’s not what I expected, what I want is to take the 3 highest values along with the owner of each value. Meanwhile, your formula will produce 3 names with the highest scores where there will definitely be 3 different names. However, this problem was resolved with @JohnSUN answer. Regards