Deriving winners from a list

[Harold]

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?

 

[John]

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

 

[Sean Timmons]

As long as it's only one per sheet...

=INDEX(Sheet1!A:A,MATCH("winner",B:B,0),1)

 

[John]

Sorry,you want info on different sheet, try this one;
=INDEX(Sheet1!A17:A22,MATCH("winner",(Sheet1!B17:B22),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]

It's just a regular formula, just use "Enter"
John