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

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

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

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

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