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
|