"Bob Phillips" wrote in message
...
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

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

"Toobi-Won Kenobi" wrote in message
...
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" wrote in message
...
=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" wrote in message
...
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