If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|