Formula to display the winner

  • Thread starter Thread starter Toobi-Won Kenobi
  • Start date Start date
T

Toobi-Won Kenobi

I have a sheet that consists of a list of team names in column B.
A running total (provided via VB) in column D which increases by the cell
value inputted into column C.
I would like to be able to find the highest value in column C and display
the corresponding name from column B in another cell. (E,F5?)

TIA

TWK
 
Assumes your teams/scores are in the range c1:c10, Try this:-

=OFFSET(C1,MATCH(MAX(C1:C10),$C$1:$C$10,0)-1,-1,1,1)

Mike
 
=INDEX(B:B,MATCH(MAX(C:C),C:C,0))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Hello Bob,

Like so many things in Excel, there is more than one way to excoriate a
feline.
I'm going to have a read now as to why it works.;)

Many thanks

TWK
 
I hope you aren't going to excoriate my cat ! <G>

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Bob Phillips said:
I hope you aren't going to excoriate my cat ! <G>
Click to expand...

Bob,

No, your formula "came up to scratch" as would your cat probably ;)
Regards

TWK
 
Back
Top