excel

[Shone33]

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

 

[Bernard Liengme]

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

 

[Gordon]

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

You don't need a formula. Just enter the total votes for each candidate and
do a sort...

 

[Gordon]

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))

Why complicate? Why not just sort and the winner is at the top? KISS!!!!!

 

[Khoshravan]

Suppose your candidate's name are in column A and number of votes are in
column B. Put this function in C1 to get the candidate name with max vote
=OFFSET(B1,MATCH(MAX(B1:B100),B1:B100,0)-1,-1,1,1)

 

[Shone33]

I am just learning excel for accounting at work and we have to enter the
formula or function to determine the winner. the contestants are in columns
b:e. My total votes are in column g. and i need to enter the winner by name
in h.

 

[Shone33]

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.