Get name corresponding to max value-CodePudding

I am having a problem with Google-Sheets, basically what I am having is a sheet where me and my mates write down our weight progress day by day. I want to get the name corresponding to max value , but I am getting an error.

The function that i've used is this:

=INDEX(B3:G3,MATCH(MAX(B2:G2),B2:G2,0))

Getting back and error, why is that? Something that has to do with the indexes not being in columns but in rows?

Thanks

CodePudding user response：

May be you need something like this

CodePudding user response：

try:

=TRANSPOSE(FILTER(B2:G3; B2:G2=MAX(B2:G2)))

or:

=QUERY(TRANSPOSE(B2:G3); "select max(Col1),Col2")