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