Deriving winners from a list

  • Thread starter Thread starter Harold
  • Start date Start date
H

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?
 
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
 
As long as it's only one per sheet...

=INDEX(Sheet1!A:A,MATCH("winner",B:B,0),1)
 
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
 
Back
Top