• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Displaying the text corresponding to the highest number in a row

Dear All,

I would request you to help me out with a formula to identify the text corresponding to the highest number in a row. I am attaching an excel file for your understanding.

Regards,
Santanu
 

Attachments

  • Kano Model Survey - sample file.xlsx
    20.7 KB · Views: 4
l4
=INDEX(B5:F5,MATCH(MAX(B4:F4),B4:F4,0))
M4
=INDEX(G5:K5,MATCH(MAX(G4:K4),G4:K4,0))

BUT
what happens if you get 2 or more answers with the same count ?

what version of excel are you using

if 365 or 2021 - with the filter and texjoin functions
then
=TEXTJOIN(" / ",,FILTER(B5:F5,B4:F4=MAX(B4:F4)))

see P4 and Q4
 

Attachments

  • Kano Model Survey - sample file - ETAF.xlsx
    20.8 KB · Views: 4
Last edited:
Hi ETAF,

I am using MS Office Professional Plus 2010. Its very unlikely to get equal counts in multiple parameters unless the size of data is too big. As of now, I can make do with this formula.

Thanks for your help.

Regards,
Santanu
 
Back
Top