Formula to display the winner

[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

 

[Guest]

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

 

[Bob Phillips]

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

 

[Toobi-Won Kenobi]

Hello Mike,

Utterly amazing!
A thousand thanks

TWK

 

[Toobi-Won Kenobi]

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

 

[Bob Phillips]

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)

 

[Toobi-Won Kenobi]

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

Bob,

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

TWK