im fairly new to excel. my winners names are in columns b5:e5, the total
votes are in g5 and i have to put the winner by name in h5.

"Bernard Liengme" wrote:

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