| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can Excel randomly pick one winner out of 100 contest entries? | Excel Discussion (Misc queries) | |||
| how to convert a formula into text in order to display the formula | Excel Discussion (Misc queries) | |||
| Display/formula help | Excel Worksheet Functions | |||
| Formula that display < | Excel Discussion (Misc queries) | |||
| Modifying a formula to display the results of another formula | Excel Worksheet Functions | |||
Linear Mode
