Starting in A1, I have
Dora 12
Jack 15
Emma 10
The name of the winner is picked out by
=INDEX(A1:A3,MATCH(MAX(B1:B3),B1:B3))
What do you want to happen if there is a draw for maximum?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"Shone33" wrote in message
...
how can I create a formula that will let me determine who will be a winner
in
a elections. I already have the each individual votes and total votes, but
I
need a formula to input the winner