| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deriving winners from a list
I have an excel worksheet where one column is a list of names and the next
column either has the word "winner" or "loser". There is only one "winner", so how do I get the "winner" to display in the first cell of the next sheet? -- HL |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Deriving winners from a list
Hi
Try this =INDEX(A17:A22,MATCH("winner",B17:B22,0)) Column A are the names, column B Winner/Looser Adjust range to your needs. HTH John "Harold" wrote in message ... I have an excel worksheet where one column is a list of names and the next column either has the word "winner" or "loser". There is only one "winner", so how do I get the "winner" to display in the first cell of the next sheet? -- HL |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Deriving winners from a list
As long as it's only one per sheet...
=INDEX(Sheet1!A:A,MATCH("winner",B:B,0),1) "Harold" wrote: I have an excel worksheet where one column is a list of names and the next column either has the word "winner" or "loser". There is only one "winner", so how do I get the "winner" to display in the first cell of the next sheet? -- HL |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Deriving winners from a list
Sorry,you want info on different sheet, try this one;
=INDEX(Sheet1!A17:A22,MATCH("winner",(Sheet1!B17:B 22),0)) This is an array formula which must be entered by pressing CTRL+Shift+Enter not just Enter. If you do it correctly Excel will put curly brackets around the formula {=INDEX(Sheet1!A17:A22,MATCH("winner",(Sheet1!B17: B22),0))}. HTH John "John" wrote in message ... Hi Try this =INDEX(A17:A22,MATCH("winner",B17:B22,0)) Column A are the names, column B Winner/Looser Adjust range to your needs. HTH John "Harold" wrote in message ... I have an excel worksheet where one column is a list of names and the next column either has the word "winner" or "loser". There is only one "winner", so how do I get the "winner" to display in the first cell of the next sheet? -- HL |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Deriving winners from a list
It's just a regular formula, just use "Enter"
John "John" wrote in message ... Sorry,you want info on different sheet, try this one; =INDEX(Sheet1!A17:A22,MATCH("winner",(Sheet1!B17:B 22),0)) This is an array formula which must be entered by pressing CTRL+Shift+Enter not just Enter. If you do it correctly Excel will put curly brackets around the formula {=INDEX(Sheet1!A17:A22,MATCH("winner",(Sheet1!B17: B22),0))}. HTH John "John" wrote in message ... Hi Try this =INDEX(A17:A22,MATCH("winner",B17:B22,0)) Column A are the names, column B Winner/Looser Adjust range to your needs. HTH John "Harold" wrote in message ... I have an excel worksheet where one column is a list of names and the next column either has the word "winner" or "loser". There is only one "winner", so how do I get the "winner" to display in the first cell of the next sheet? -- HL |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deriving P-Value through LINEST Function | Excel Worksheet Functions | |||
| Deriving from 0.5" to 0.5 and so on ..... Values only. | Excel Discussion (Misc queries) | |||
| Winners & Losers | Excel Worksheet Functions | |||
| listing winners formula | Excel Discussion (Misc queries) | |||
| Deriving mathematical equations | Excel Worksheet Functions | |||
Linear Mode
