Home > Software design >  I Need excel formula for the following content
I Need excel formula for the following content

Time:04-07

enter image description here

In the Image aboveI have 3 persons with no of votes they got. So, now I need the winner name in a new column with a green colour background. Please help ... Thanks in Advance

CodePudding user response:

Assuming the data you give is in A1:F2, in G2:

=XLOOKUP(MAX(B2:F2),B2:F2,A2:E2)

CodePudding user response:

When you put your data in B9:I9, you can use following formula:

=OFFSET(B9,0,MATCH(MAX(B9:I9),B9:I9,0)-2)

This does the following:

  • Take the maximum value from the row (MAX() function).
  • Verify where it is located (MATCH() function).
  • Go 1 to the left (the -2 is a combination of -1-1) (OFFSET() function).
  • Related