excel
 

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

excel
 

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

excel
 

"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


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

--
Asking a question?
Please tell us the version of the application you are asking about,
your OS, Service Pack level
and the FULL contents of any error message(s)

excel
 

"Bernard Liengme" wrote in message
...
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!!!!!

--
Asking a question?
Please tell us the version of the application you are asking about,
your OS, Service Pack level
and the FULL contents of any error message(s)

excel
 

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)
--
R. Khoshravan
Please click "Yes" if it is helpful.


"Shone33" wrote:

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

excel
 

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.
"Gordon" wrote:

"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


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

--
Asking a question?
Please tell us the version of the application you are asking about,
your OS, Service Pack level
and the FULL contents of any error message(s)

excel
 

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