View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toobi-Won Kenobi Toobi-Won Kenobi is offline
external usenet poster
 
Posts: 6
Default 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