Formula to display the winner
 

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

Formula to display the winner
 

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

"Toobi-Won Kenobi" wrote:

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

Formula to display the winner
 

=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

Formula to display the winner
 

Hello Mike,

Utterly amazing!
A thousand thanks

TWK

"Mike H" wrote in message
...
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

"Toobi-Won Kenobi" wrote:

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

Formula to display the winner
 

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

Formula to display the winner
 

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" 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

Formula to display the winner
 

"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