excel

  • Thread starter Thread starter Shone33
  • Start date Start date
S

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
 
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
 
Shone33 said:
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
Click to expand...


You don't need a formula. Just enter the total votes for each candidate and
do a sort...
 
Bernard Liengme said:
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))
Click to expand...


Why complicate? Why not just sort and the winner is at the top? KISS!!!!!
 
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)
 
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.
 
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.
 
Back
Top